copying between workbooks

D

Douglas

I have a user who wants to copy formulas from one workbook to another. The formulas reference multiple sheets in the same workbook (e.g =Sheet2!A1). When he copies and pastes them into the new workbook, they look like this: =[Book1]Sheet2!A1. Is there a simple way for him to copy these formulas from one workbook to another without adding the [Book1] link

Thanks
 
J

Jason Morin

1. Select the range containing the formulas.
2. Press Ctrl+H.
3. Replace "=" with "##" (no quotes).
4. Copy to the new workbook.
5. Ctrl+H, replace "##" with "=".

HTH
Jason
Atlanta, GA
-----Original Message-----
I have a user who wants to copy formulas from one
Click to expand...
workbook to another. The formulas reference multiple
sheets in the same workbook (e.g =Sheet2!A1). When he
copies and pastes them into the new workbook, they look
like this: =[Book1]Sheet2!A1. Is there a simple way for
him to copy these formulas from one workbook to another
without adding the [Book1] link?
 
T

tbrown_dytn

You could do a find/replace on Book1.
-----Original Message-----
I have a user who wants to copy formulas from one
Click to expand...
workbook to another. The formulas reference multiple
sheets in the same workbook (e.g =Sheet2!A1). When he
copies and pastes them into the new workbook, they look
like this: =[Book1]Sheet2!A1. Is there a simple way for
him to copy these formulas from one workbook to another
without adding the [Book1] link?
 
Top