Microsoft Office Tutorials and References
In Depth Information
Copy a Worksheet
If you want to copy the sheet to another open workbook, click the To book list
arrow, and then select the name of that workbook. The sheets of the selected
workbook appear in the Before Sheet list.
If the workbook you want to copy to does not show up in the To Book
drop-down list, you must first open the workbook.