03 Nov
How to copy or move worksheets between workbooks
To copy or move worksheets between workbooks follow these steps:
1. Switch to the workbook which has the sheet to be copied or moved.
2. in the Edit menu click Move or copy sheet.
3. The Move or copy dialogue will open.
4. In the To book drop down select the destination workbook. You can also choose to create a new workbook.
5. in the Before sheet list click where you want the sheet to be moved (position within the workbook).
6. Select the Create a copy check box if you want the worksheet to remain in the original workbook, or deselect it to move the worksheet completely and delete it from the original workbook.
Applies to Excel 2003
