target workbook

Before using the mouse to move or copy a sheet between workbooks, both the source and target workbook files must be open. Follow the steps below: Open both workbooks and choose Window | Arrange. Choose Tiled. Choose OK. When moving or copying to a ... new workbooks, it is not necessary to create the workbook first. When the sheets are dragged to an empty area on the desktop, a new workbook is automatically created. Select the tab(s) of the worksheet(s) to be moved or copied. To move the sheet(s), drag the tab(s) from the source workbook to the target workbook. Or: To copy the sheet(s), press CTRL ... (view more)