I like to change my formulas to text:

Edit|replace
what: =
with: $$$$$= (some unique string)
replace all.

Then copy|paste

Then convert the text back to formulas (in both workbooks).
Edit|replace
what: $$$$$= (that same string)
with: =
replace all.


===
Another option would be to change the links on the "pasted" worksheet.

Edit|links|change source
and point at the current workbook


slvrblt wrote:

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

--

Dave Peterson