Copying a Worksheet into another Workbook

How to make a copy of a Worksheet from the current Workbook to another Workbook?

1. Open the Target Workbook, when the Source Workbook is already in open state.
2. Right-Click on the Source-Worksheet Tab.
   
3. Select the Move or Copy... option from displayed shortcut menu.
4. Select the Target Workbook name from the To Book: drop-down list.
   

Put a check-mark in the Create a Copy option and click OK.

There you are, you have a clone of the source worksheet on your Target Workbook.

Instead, if you want to move a worksheet to the target Workbook, select (Move to End) option.

Read More