In order for you to move the sheet from one workbook to
another we have to follow few simple steps which will allow you to move sheet
from one workbook to another.
1.
First of all open the workbook and select the
sheet which you want to move. Let consider the below example where “details”
sheet need to be moved to another sheet.
2.
Right click on details tab and select “ move or
copy” which will bring up a pop up windows as shown below in image
3.
Now you will have 2 section here, one is the “To book” – Select the workbook were you
want to move and “Before sheet”- The
sheet which you need to move
4.
Select the Workbook you want to transfer under
the “To Book “ and Select the sheet which you need to move under the “before
Sheet” section.
5.
Click on Ok and you are all set, the sheet will
be moved to another workbook in the below image it is the example 2
6.
Similarly the coping sheet from one workbook to
another can be done, the only change is you need to put a check mark on the “move
or copy” pop up window.
