Copying Formulas from Workbook to Workbook
If there's only a single formula (or a limited number), I copy each from the
formula bar and paste into the formula bar.
If there are a lot, I'll select the range to copy
edit|replace
what: = (equal sign)
with: $$$$$=
replace all
Now those formulas are just text.
Edit|copy
followed by Edit|paste
And then do a couple of edit|replaces to change those text strings back to
formulas
Select the range
edit|Replace
what: $$$$$=
with: =
replace all
In both the original worksheet and the newly pasted worksheet.
Rupert wrote:
How does one copy a formula from one workbook (WB) to another without the new
formula not referencing back to the orginal workbook? E.g. when I copy a
formula from WB1 that adds two cells in WB1 together and paste it into WB2
the formula now in WB2 still adds the 2 cells in WB1 and posts the result in
WB2. I want the just formula to be copied so that the two cells added are
from WB2. Paste Special doesn't help.
--
R H Ingram
--
Dave Peterson
|