Copying and Pasting a Worksheet

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
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?
 
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
 
Back
Top