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

Related posts:

1. How to make your macros and functions available to all workbooks
2. How to view multiple worksheets at the same time
3. How to create and use a workspace file
4. How to automatically save a backup copy of a workbook
5. Change the number of the recently used workbooks