Forum Discussion
Excel workbook
How do I copy an excel worksheet from a workbook onto another workbook without losing the format, formulas and pivot tables?
Open both the source workbook and the target workbook.
Right-click the sheet tab of the source sheet.
Select 'Move or Copy...' from the context menu.
Select the target workbook from the 'To book:' drop-down.
Specify where you want to position the copied sheet in the target workbook.
Click OK.