Copy formula from one workbook to another without referencing original workbook?

Copper Contributor

How can I copy a formula that references other cells in a workbook to a new workbook without referencing the source workbook still included in the formula on the second worksheet?

3 Replies
Copy from formula bar in source. Paste into formula bar in destination.



Thanks so much - it's working great.  I knew there had to be a way to do it!