software

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: www.excelforum.com/member.php...oamp;userid=28201
View this thread: www.excelforum.com/showthread...hreadid=494593I 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:
gt;
gt; Hi there,
gt; How can I select a range of cells in a file, and copy those in a
gt; different file without having all formula contain the name of the
gt; former file?
gt;
gt; thx,
gt; jm
gt;
gt; --
gt; jmwismer
gt; ------------------------------------------------------------------------
gt; jmwismer's Profile: www.excelforum.com/member.php...oamp;userid=28201
gt; View this thread: www.excelforum.com/showthread...hreadid=494593

--

Dave Peterson

Dave Peterson wrote

gt; I like to do this:
gt;
gt; Change the formulas to strings, copy the ranges, paste the ranges, and
gt; 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: www.excelforum.com/member.php...oamp;userid=28201
View this thread: www.excelforum.com/showthread...hreadid=494593