Currently i have 2(too big for one) excel databases that show my huge cd
collection ie: artist/track/cd/time/cd number
the files are too big to be shown on my ipaq and would take all day to
open...so i have to split them up i do it like

I need to manipulate an excel file that contains relay results from a summer
swim leauge. I need to take a row that looks like this:
TEAM    DATE    MEET    SWIMMER1    SWIMMER2    SWIMMER3    SWIMMER4
and turn it into 4 rows that look like this

How easy a macro can be developed to remove the formula but leave the value
alone for a group of cells when a special condition matches like my example
here?
I started with the formula below but realized that I can’t get the result I

Using WinXP 2003 SP2 and MSOffice2003 with all updates
I have a wb with 62 wss, 1 for each vendor (sheet name = vendor name)
Each vendor ws has cols for ProdNo, ProdDesc, UOM and a few cols for
pricing levels:

l would like to protect my  work from other user not all but for the certain
column.for example ; column A 1,A2 ,A3 ,B1 B2,B3 ,C1,C2.C3 and  D1.D2 D3 are
for write only.{ Column A23, A24,A25 ,B23,B24,B25 ,C23.C24,C25 and
D23,D24,D25 ,all the data here are copy from above like A23 ...

If my headings are in Cols. A & B and the other Cols. ad infinitum contain
the information, is there a way of rolling the information Cols. under the
headings Cols. so that I can use Cols AA, BB ect., ect.?

given all the drug names to make a file with the generic and the brand names
with the therapuetic classification how can you make a file out of that?

I have a speed sheet that calculates the number of days required to get a
project completed.
in a feild it calculated the estimated completion date based on the new
start date each morning.

I click on the printer icon in Excel and get a "Save As" screen.  The "Save
As" screen leads nowhere.  What's wrong?  What can I do?
                                             Don J
------------------------------------------------------------------------

I am having trouble even verbalizing this, but here it goes.  I need:
80=1
90=2
100=3

I have some VBA code (using Alt+F11 key) in an Excel file that I use for my
work.
I have used the password option for the project using a simple combination
of keys (I thought I used 1234) for the password but it seems that I was

Using MSOfficePro 2003, winxp proSP2
I want to generate a worksheet by grabbing some sheets from a different
wb - then dumping certain columns from the sheets I grabbed.
I have a table that contains CustName, CustStreet, CustCity, Vendor1,

Is there a way I can get Excel to "execute" an expression that is
stored in a cell as a test string?
Say C4 contains "3+4". Can I put some expression in C5 that will
execute that expression and result in "7"?

I’m using excel 2007with windows xp pro.  I use excel very infreuently and
not since upgrading to 2007.
I have a long column of dollar values that I need to change from positive to
negative values such as:

I have a column of numbers with 2 decimal places (monetary amounts).  If copy
and paste into excel, it converts them to text.  If I import the text as a
text file, excel converts it to text.  If I open the text file (which has a
column of numbers and nothing else), excel converts ...