try

1) Click on sheet tab you want to transfer to another workbook
2) Place your mouse on the sheet tab and right click
3) Choose Move or Copy
4) Under the To book, Select the workbook name you want to move the sheet to
( Note the target workbook must be open, if you want to move to a new
workbook, just choose new book from the drop down )
5) click OK

This will move the sheet to the new workbook
--
Hope this is helpful

Appreciate that you provide your feedback by clicking the Yes button below
if this post have helped you.


Thank You

cheers, francis










"Paul" wrote:

How do I get the same informationton to automatically transfered to another
sheet using an old version of XL.