Moving a sheet from one work book to another?
 

I have a few work books that can use the same sheet. if I copy the
sheet from one work book to another, I have to go into all the
formulas and remove the referance to the old work book.

is there any way to copy the sheet over and have it work in the new
workbook without reduing all the formulas?

Thanks for your help

Wally

Moving a sheet from one work book to another?
 

EditLinks
will help you do this in one shot.
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"WTG" wrote:

I have a few work books that can use the same sheet. if I copy the
sheet from one work book to another, I have to go into all the
formulas and remove the referance to the old work book.

is there any way to copy the sheet over and have it work in the new
workbook without reduing all the formulas?

Thanks for your help

Wally