Copy a worksheet from one workbook to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 12 Jun 2007 16:09 GMT

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.

Reply to this Message

Ron de Bruin - 12 Jun 2007 16:22 GMT

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 =

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>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.

Reply to this Message

Ron de Bruin - 12 Jun 2007 16:25 GMT

Oops

Use $$$$
@@@@ is not working

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> You can do this Joe
>
[quoted text clipped - 14 lines]
>> to cells in other worksheets of the workbook;
>> So I need that the formula points the same cells of the new workbook.

Reply to this Message