Copying a Worksheet into another Workbook 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 ... Read More