Copying formulas

[Hrider]

How can I copy a formula with cell references in a worksheet within a
workbook to another worksheet in another workbook without including the the
workbook reference that automaticly gets included when I paste the formula
in the new workbook.

 

[RagDyer]

Couple of ways:

Select the *entire* formula in the formula bar.
Right click in the selection and choose "Copy",
Then hit <Enter>
Then paste it anywhere you wish.

OR

"Unformulate" the formula by removing the equal sign.
Now it becomes simple text.
Copy and paste anywhere.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================