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

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

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


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

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.


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

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

Thanks Dave! That works like a charm!


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