How to make a copy of a Worksheet from the current Workbook to another Workbook?
- Open the Target Workbook, when the Source Workbook is already in open state.
- Right-Click on the Source-Worksheet Tab.
- Select the Move or Copy... option from displayed shortcut menu.
- 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.
