How can I delete a list from a column?
Hello all -Excel 2003-
I have a column L that call a list. When I want to insert a new column in
M, this M columns takes also the list of L.
I have now the same list in L and M. How can I delete the list from M?
Thanks a lot.
Select the column and Edit>Clear>Contents.
Gord Dibben MS Excel MVP
On Mon, 14 Aug 2006 11:20:51 +0200, "Casrlos A." <firstname.lastname@example.org> wrote:
>Hello all -Excel 2003-
>I have a column L that call a list. When I want to insert a new column in
>M, this M columns takes also the list of L.
>I have now the same list in L a...Reports from outlook
When i run a report from my workstation than he always ask for my
credentials. When i logon to the server locally with my credentials then it
works. The CRM 3.0 and SQL 2005 server are running on the same server. How
can I solve the problem that i can run a report from the outlook client?
...can a column have diffent width?
I have dates in column A and 20 rows down or so, I want to have names in
column A and numbers in column B but column A must be wider to accept the
I want the dates to be a certain width say 64 pixels and the names to be 336
pixels,can this be done?
No, a column has one width from top to bottom
Bernard V Liengme
remove caps from email
"dave" <email@example.com> wrote in message
>I have dates in column A and 20 rows down or so, I want to have names in
>...Table / Column descriptions
Is there ANYWHERE that you can find what the column names in each table
represent ? Such as there is a column in the SOP10200 table that is
PURCHSTAT. Some of them are a 1 and some are a 2. What does this represent
Where can we find out a detailed list of what these columns are in the
Why does MS not provide this ? Is it a secret or is it just because they
dont even know ?
This is VERY frustrating in trying to troubleshoot Great Plains .... or
shoud I say Great PAINS !!
Accolade has been the best so far, just not as detailed as one would need
for accurate tro...Excel: Ignoring Specific data in a column
I have Excel data (raw) that I am importing into an Excel sheet which
has my formulas). I am trying to add up a column of numbers, but some
of the fields have the letter's "N/A"
Presently I am using formula =sum(A10:A15000), but it is not working
due to the "N/A". How can I get Excel to ignore the "N/A" and just add
the cell's that do have the numbers.
For reference, the numbers do have decimal points (xx.xx)
If the N/A are just text, then select the column and use find/replace to make
them all zeros.
If the N/A are the result of fu...Multiple Column Sorting
I've been reading online about sorting multiple columns and I'm confused.
Selecting one column to sort also selects all the other columns as well, at
least in Excel 2000 and XP. I didn't see any difference in selecting one
column or using the "Then by" boxes, in fact, the "Then by" choices didn't
work. If the first column sorted in ascending order, and I chose to sort the
second and third columns to sort in descending order, Excel still sorted all
three columns in ascending order.
If Excel sorts the all the columns together by default, why use the "Then...Property Tax Reporting
The Fixed Assets tutorial on PartnerSource very briefly says that the
Location ID in Fixed Asset Management factors into property tax reporting.
How so? There are no property tax rates or calculations in Fixed Asset
Speaking of reports, it would be nice if Fixed Asset Management had forms of
some sort that it could print. What I mean by that is that certain CPA firms
use other software such as Thomson Creative Solutions as it prints out the
necessary tax forms for the client. Do you think Fixed Asset Management will
eventually have this? It would make it more ...Date Range on Report in Money 2003
I have a favorite report in Money 2003 which lists scheduled payments
within a range of dates.
My file was upgraded from Money 2000.
I used to have the problem of the report omitting many of the
scheduled transactions within the date range. That was fixed by
running the Salvage program.
Now the problem is the other way around: the report shows transactions
BEYOND the date range, as well as those within.
Is there a fix for that? I still have the Salvage program. :-)
...Sales Tax reporting on cash payment
Great Plains only allows us to report Sales Tax at time of invoicing. I would
love to see a Sales Tax reporting setup option in which you are asked, how do
you report? Time of INvoice or Time of Receipt.
This was a feature of RealWorld software that anyone who upgrades to Great
Plains has lost this functionality and now has to record their sales tax
manually if they pay their sales tax based on when the Receivable Invoice is
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click t...Column Labels #5
I have a coworker who changed the column labels from
letters to numbers. She does not know how she did it. Does
anyone know how to change them back to letters. The
columns are numbered in all of the worksheets that she
"Stephanie" <firstname.lastname@example.org> wrote in message
> I have a coworker who changed the column labels from
> letters to numbers. She does not know how she did it. Do...schedule a task to run a report
I need to use the Windows task scheduler to run a report, I can see how to do
this if the access file is closed. What if the file is currently open ?
Message posted via AccessMonster.com
use a different database for the scheduler task ...
link to all your tables, put your report in there and
anything else it needs
create an AutoExec macro that opens the report (which will
automatically print unless you specify otherwise) and then
...Mailbox Management Report is blank
I set up a policy to Generate a report of all users Sent and Deleted
Items folders. I set the reporting level to Summary as a test and also
Detail as a test. Each time I run the Mailbox Maintenancde Process,
the email gets sent to the administrator I chose but it is blank. Even
on the detail attachment it is blank. The event viewer log shows the
correct information that should be on the report, but the email is
blank. Any ideas? Does the exchange server need a MAPI client
installed like 5.5 needed?
You shouldn't install Oultook on your exchange server.
I've run into problems wi...summing number of 'y's in a filtered column
Basically I have a spreadsheet which is filtered by column R and I wan
to sum the number of 'Y's in column P based only on the visibl
filtered table rather than hidden rows.
Now I know the subtotal worksheet function will ignore hidden rows
however it does not seem to be able to total up the number of 'Y's i
the range of cells. The count function would sum up the number of 'y'
but it counts the hidden columns as far as I know.
Is there some other function which would allow me to sum the number o
'y's ignoring hidden rows
---------------------------...display last value in a column
I would like to display the last value unequal to zero recorded in a column
in a specific cell. For example, A1 is to display the last value unequal to
zero recorded in column B. The number of entries and values in column B
changes frequently; therefore the last value in column B is in a different
Assuming there are no logical TRUE entries in the range.
Microsoft Excel MVP
"Mike" <Mike@discussions.microsoft.com> wrote in message
news:DFFCBDB0-3632-46AC-A3AB-073E6F0D475...Omit data based on criteria in reports
I have a report which gives an employee's productivity rating, based on a set
standard. This standard depends on what product the employee is running at
the time. However, some times the employees run products that do not have
standards associated with them (trial products for instance).
A daily report tells:
Employee Product How much was produced How much was
expected (standard) % Expected (How much was produced/How much was
When a trial product is run on a given day, the % Expected number is Null
(=IIf([How much was expected] = 0, Nul...Field values used to filter a report
I have a report that is based upon a query that filters the data in a variety
of ways. The net result is a listing of Zip Codes that I ultimately use as a
part of the data for a report. The contents of this report is limited to the
Zip Codes from the query. (Not a true filter) I need to be able to print this
list of zip codes in a comma seperated list in the report header. I am sure
this can be easily accomplished but for the life of me I cannot figure this
out. Any help would be greatly appreciated.
Thanks in advance.
There are 2 parts to your question:
a) How to provide an interface ...Products added directly to Opportunity
Why can't I link and display products when they are added directly to an
I can do it using Access but not with CRM tools - Reports or Advanced Query.
I need a list for a date range of all products sold by Owner. The sales team
do not use Orders or Quotes. Our partner said it would work fine to just add
the product directly to the Opportunity. Only problem, no reports!
Any help greatly appreciated.
On the left-hand side of the Opportunity screen, there is a section titled
'Products' which lists the Products that are potentially been sold as part ...How do I sort data in column B to align with data in column A?
Im fairly green to Excel but what I am after is I want to be able to sort a
range of codes in Column B to basically move and realign to the same row as
the data that is in Colmn A eg
Column A Column B
Column A Column B
Piece a cake.
Delete columm B, then copy column A and paste into Column B
> Im fairly green to Excel but what I am after is I...How do I sort a column consisting of fractions, decimals, and who.
I need to sort products by the horsepower. Horsepower can be a fraction,
decimal or whole number. For example, I need 1/100 to come before 1/10,
1/125 to come before 1/12, 1/10 to come before 1.0, 3/4 to come before
Why don't you use the Fraction format under Number format?
That way you only enter the decimal value and it will be represented by it's
fraction, but the sorter won't be confused.
Another option is to use this formula:
Where E8 is ...Text to Columns #4
I have a list of the Fortune 1000 companies in one cell.
Is there a way to convert this information into columns
Company City State Telephone
1 Wal-Mart Stores, Inc. Bentonville, AR 479-273-4000
2 Exxon Mobil Corporation Irving, TX 972-444-1000
3 General Motors Corporation Detroit, MI 313-556-5000
4 Ford Motor Company Dearborn, MI 800-392-3673
5 General Electric Company Fairfield, CT 203-373-2211
6 ChevronTexaco Corporation San Ramon, CA 925-842-1000
7 ConocoPhillips Houston, TX 281-293-1000
8 Citigroup Inc New York, NY 212-559-1000
9 International Business Machines Corporatio...How to increase number of columns appear in a worksheet?
You only get 256 columns with any released version of excel.
...Comparing three separate reports #2
I'm trying to take three separate reports and extract the data that is the
same in column a and b. This report will pull the entire line of data based
on a and b being the same on all three reports.
Example is a financial institution looking for customers by name and account
# that appear delinquent for three consecutive months.
Create a new sheet. We will use columns A through C will be used in the process for finding the
duplicates, so we'll set those up first.
Enter "Table" in cell A1, and enter "Key Value" in cell B1, and enter "Appears in 3&qu...Worksheet 'shape' (#columns by #rows)
Have a problem here in that we would like to import some data into a
spreadsheet, but the data array is 512 by 512 elements. Excel seems to
force a limit of 256 columns. Is there a way to change the array shape?
In any Excel version 97-2003.
Royal Military College
The reasonable man adapts himself to the world;
the unreasonable one persists in trying to adapt the world to himself.
Therefore all progress depends on the unreasonable man.
- George Bernard Shaw
there is now way to change this limitation (Ex...Free Form Text Box in Report
I am running a report that runs from a Make Table Query, and then into a
cross tab query. The report is in a Switchboard and runs off of a Macro that
opens the make table, updates based off of the dates entered, closes it,
opens the cross tab. Closes it. Opens the report in print preview. I need
others to run the report with no intervention so I entered a text box (as I
have done before) into the header that reads: =[Enter Report Ending Date
mm/dd/yyy] to allow for the ending date to appear in the header. However,
this is not working. I am recieving the following error &q...How can I hide check box created via FORMS together with column?
Hey guys, how can I hide a check box created using FORMS together with column
it is placed in (or in some other way). "Move and size with cell" option is
not active in object positioning for check boxes created via FORMS as opposed
to those created via CONTROL TOOLBOX.
I think you'll have better luck (pronounced easier time!) with the checkboxes
from the Control toolbox toolbar.
But maybe you could have a macro that hides the columns/rows and also looks at
the objects to see if they should be .visible = false.
And the same kind of macro to make the checkbox...