Copy Excel Sheet To Another Workbook. On the move or copy dialog box select the workbook into which you want to copy the worksheet from the to book drop down list. Right click on the tab for the worksheet you want to copy and select move or copy from the popup menu.
Under before sheet choose where you want to place the copy. You can use the cut and copy commands to move or copy a portion of the data to other worksheets or workbooks. You can use the move or copy sheet command to move or copy entire worksheets also known as sheets to other locations in the same or a different workbook.
Here in the move or copy dialog option select the target sheet and excel will only display the open worksheets in the list else if you want to copy the worksheet instead of moving then kindly make a copy of the excel workbook before lastly select the ok button to copy or move the targeted excel spreadsheet.
Put a tick in the create a copy box. Step 1 make sure both workbooks are open in excel the workbook from where the worksheet is copied and the workbook to where the worksheet is copied or moved. In the move or copy dialog box click on the to book drop down and select the workbook name to which you want to copy the selected sheets check the create a copy option if not checked your sheets will be removed from the current workbook and moved to the new one. Here in the move or copy dialog option select the target sheet and excel will only display the open worksheets in the list else if you want to copy the worksheet instead of moving then kindly make a copy of the excel workbook before lastly select the ok button to copy or move the targeted excel spreadsheet.
