Moving worksheets to new workbook

[wally]

I have a workbook with multiple worksheets. Each worksheet tracks activity
for a specific item during a period of time. Upon completion of recording
the activity during the tracking period, I need to move the worksheet, for
that specific item, from that workbook, to a different workbook for completed
records.

I need help in how this can be done.

Wally

 

[Mike Rogers]

wally

With both workbooks open, from the workbook you want to move the one sheet.
Right click on the sheet tab you want to move, from this menu select "Move or
Copy". Under the "To Book" drop down select your <Destination> workbook. I
would also select "Create a copy" and click "Ok". If all was as I wanted it
I would then go back and delete the one from the original work book that I no
longer needed.

Mike Rogers

 

[wally]

Thanks. I think that will do it.

Wally

wally

With both workbooks open, from the workbook you want to move the one sheet.
Right click on the sheet tab you want to move, from this menu select "Move or
Copy". Under the "To Book" drop down select your <Destination> workbook. I
would also select "Create a copy" and click "Ok". If all was as I wanted it
I would then go back and delete the one from the original work book that I no
longer needed.

Mike Rogers

 

[Mike Rogers]

wally

Glad to help!! Thanks for the feed back.

Mike Rogers