Anne

Save workbook1 and leave open.

Open workbook2.

With workbook1 active, right-click on the sheet tab you want to send to
workbook2.

Select "Move or Copy" and select workbook2 from "to book". Do not select
"create a copy".

Hit OK and it's done.

Go back to workbook1 and close without saving.

Now do whatever you want with workbook2.


Gord Dibben Excel MVP

On Thu, 17 Mar 2005 10:29:03 -0800, "Anne"
wrote:

I want to use the move/copy worksheet function to copy a worksheet from one
workbook to another. When I do this I want it to Not refer to the workbook it
was copied from in the formulas and lookups. I have tried copy/paste special
also and it doesn't work.