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 between two different files, not two sheets in the same file. You cannot group 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


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

[slvrblt]

Thanks Dave! That works like a charm!