Copy formulaS between Workbooks

  • Thread starter Thread starter Syslock
  • Start date Start date
S

Syslock

This might be some sort of follow up question from Ken Runge post "Cop
formula between Workbooks" from Oct-23-2003. I would like to copy som
formulas from one workbook to another without getting a reference t
the original workbook
 
Syslock,

This happens, I think, where there are cell references to other sheets. One
way is to copy the text of the formula (drag across the text in the formula
bar), instead of the cell. Cell references won't adjust relatively when you
paste, though, though copying the pasted formula in the target workbook will
do so, so you can still make it work.
 
Syslock,

Don't copy the cell. Select and copy the formula text in the the
"Formula Bar" above the worksheet. At least that's what I do.
 
One method is to select the range of formulas in book1 and Edit>Replace

what: =
with: xx=

Do your copy over to book2 then reverse the Edit>Replace

Gord Dibben XL2002
 
And how about to copy a register from one worksheet to another where
also get the reference to the original
 
Back
Top