Copy a worksheet from one workbook to another


G

Guest

I need to copy a worksheet from one workbook to another similar one with the
same worksheets, and I have a formula inside this worksheet that references
to cells in other worksheets of the workbook;
So I need that the formula points the same cells of the new workbook.
 
Ad

Advertisements

R

Ron de Bruin

You can do this Joe

Select all cells
Edit Replace

Replace
=
With
@@@@

Or something else that is unique

Then copy the sheet and replace @@@@ with =
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top