copying between workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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?
 
Back
Top