Moving a Worksheet to Another Workbook

As you develop more and more Excel workbooks, you may have the necessity of moving a worksheet from one workbook to another. You can do this by following these steps:

1. Make sure both the source and target workbooks are open.
2. Display the worksheet you want to move.
3. Choose Move or Copy Sheet from the Edit menu. This displays the Move or Copy dialog box. (Click here to see a related figure.)
4. Using the To Book pull-down list, choose the name of the target workbook. The list of worksheets in the Before Sheet list will change to reflect the workbook you selected.
5. In the Before Sheet list, select the worksheet that should come after the worksheet you selected in step 2.
6. Click on OK. The worksheet is moved.