copy/paste from one file to another without file name reference

[slvrblt]

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.

 

[cycling-rod]

The answer may be here:
http://www.j-walk.com/ss/excel/usertips/tip066.htm I haven't tried it
out, but it may do the job.

 

[slvrblt]

Thanks but that doesnt work in this case. I am trying to copy betwee
two different files, not two sheets in the same file. You cannot grou
two sheets together that are part of separate files.

Anyone else have any suggestions? Thanks

 

[Dave Peterson]

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

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]

Thanks Dave! That works like a charm!