Hi there. Here is my problem: I have two files, Model A and Model B. I
need to copy multiple cells containing formulas from Model A to Model
B.

Original Forumla in Model A:
=1000000/Fuel_Specs!C8*Fuel_Specs!D8

When copied into Model B:
=1000000/'[NEW MODEL 01.30.05.xls]Fuel_Specs'!C8*'[NEW MODEL
01.30.05.xls]Fuel_Specs'!D8

It is referencing the file name of Model A when copied into Model B.
How do I eliminate this so only the formula pastes. (Sheet names in
Model A and B are identical.)

I could double click each cell, highlight the formula and then copy it
over, and it works. But I have about 3000 cells that need to be copied
and would like to be able to highlight multiple cells at once and copy
over.

Please help! Thanks in advance.


--
slvrblt
------------------------------------------------------------------------
slvrblt's Profile: http://www.excelforum.com/member.php...o&userid=19521
View this thread: http://www.excelforum.com/showthread...hreadid=342714