Moving worksheets to new workbook

  • Thread starter Thread starter wally
  • Start date Start date
W

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
 
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
 
Thanks. I think that will do it.

Wally

Mike Rogers said:
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
Click to expand...
 
Back
Top