How do I use the custom formatting to get this result?
...Lisa

I have a workbook with a two worksheets.
Worksheet1 is like a parts table it has a listing of parts (windows)
Window item,  Cost of window, cost of screen, cost of grill.
Worksheet2 is like a purchase order.

I need a function to check a cell for text (general data) and if it exists in
one cell transfer (copy) to another cell...for example cell A2 is blank so
the cell F2 is also blank, however if A2 has data in it say N 90-00-00 W then
the same would be reflected in cell F2... I'm ...

I have a pivot table that tracks my medical expenses and insurance
benefits.
The layout uses the "Provider" field as a PAGE filter, and so I can see
which provider is being displayed when I choose their name from the

I am quite sure, in a long forgotten history, Lotus 1-2-3 had an option
allowing one to switch column contents to rows and vice versa. I must be
looking for the wrong keywords in help and google, can someone tell me
how to swap rows and columns in excel? Alternatively, same question ...

I have an estimating program file with 30+ worksheets in which I need to be
able to specify a specific range name from four available, then paste the
data from a 5 column by 6 row range relating to that named range to a
different worksheet to calculate overheads, field ...

Is there a way to count the specific instances/occurances of dates?
I may run as many as 3 delivery trucks on a specific day. On some days
no trucks run.   I want to count how many days in a month I deliver.
Without counting the multiples.

Hi to all
I am trying to import a works database into excel.
I can convert database to CSV etc but on importing to or opening in
excel the text in each cell is truncated to 256 characters.

I have hidden the MENU BAR using a macro command on purpose.
For the user to 'save/save as' his work, I plan to have a button on that
worksheet. The user can open the FILE menu, using that button when pressed.
Can someone suggest a macro command for that button to work the way I ...

I do have three columns where as the first two are combo.
I want that after choosing the value, the neighboring cell, for the
second combo is activated (selected). And after that, the thrird cell
is activated. How to perform in VB, and for 50 rows together?

I need to aIphabetize columns with a set start column, but a variable
range for the end column.
Thanks,
Bern

I am trying to save a file to a floppy disc. Can't find a way. Help!!