Copying and Pasting a Worksheet

J

Jim Pockmire

I am copying and pasting a worksheet from another workbook into one I am
using. The worksheet has references to other cells. How can I change the
reference to cells in the current workbook as opposed to the cells in the
other workbook?
 
D

Dave Peterson

I like to change all my formulas to text, copy and paste and then change my text
formulas back to formulas.

Select your range to copy (whole sheet??)
edit|replace
what: = (equal sign)
with: $$$$$=
replace all

Copy and paste

then change them back (in both worksheets)
edit|replace
what: $$$$$=
with: =
replace all
 
Top