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


--
jmwismer
------------------------------------------------------------------------
jmwismer's Profile: http://www.excelforum.com/member.php...o&userid=28201
View this thread: http://www.excelforum.com/showthread...hreadid=494593

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).

jmwismer wrote:

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

--
jmwismer
------------------------------------------------------------------------
jmwismer's Profile: http://www.excelforum.com/member.php...o&userid=28201
View this thread: http://www.excelforum.com/showthread...hreadid=494593

--

Dave Peterson

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.

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

--
David

nice one. good thinking, thank a lot!
jm


--
jmwismer
------------------------------------------------------------------------
jmwismer's Profile: http://www.excelforum.com/member.php...o&userid=28201
View this thread: http://www.excelforum.com/showthread...hreadid=494593