copy formula to new workbook without [REFERENCE]

C

Clayman

I need to copy a whole series (3x30 range) of formulae from one workbook to
another. I'd like to copy without the reference to the original workbook. Is
this possible?

signed: frustrated...
 
S

Sean Timmons

What I do for simplicity's sake:

Copy all the formulas over
Go into the address bar for one of the cells.

Copy everything from the initial ' to the second '

get out of the cell

Edit/Find/Replace

Paste what you copied in the find

Replace with blank

OR, if reference is to a different tab, replace with tab name.
 
C

Clayman

HOT DIGGITY!

That did the trick! Thanks!

Here I was trying to be too complex....
 
S

Sean Timmons

To use Excel, you need to be a buddhist. Imagine the sound of one hand
clapping. :)

Thanks for the feedback...
 
Top