copy formulaes w/o filename

J

jmwismer

Hi there,
How can I select a range of cells in a file, and copy those in a
different file without having all formula contain the name of the
former file?

thx,
jm
 
D

Dave Peterson

I like to do this:

Change the formulas to strings, copy the ranges, paste the ranges, and then
convert them back to formulas.

Select the range to copy in the original workbook
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Then copy|paste. Since you're just pasting strings (not formulas), they won't
point back to the old workbook.

After you paste, do the opposite:

Select the pasted range
edit|replace
what: $$$$$
with: =
replace all

Do it for both ranges.

And don't forget to fix the original workbook (or close it without saving).
 
D

David

Dave Peterson wrote
I like to do this:

Change the formulas to strings, copy the ranges, paste the ranges, and
then convert them back to formulas.
Click to expand...

And for a single formula, I do this:
Select formula in Formula Bar
Copy
ESC
Select destination cell
Paste
 
Top