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

[WeeWillie390]

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?

[#2]

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

[#3]

@Patrick2788,

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

[#4]

Glad to help. You're welcome!