Copy a sheet from one workbook to another workbook

[geoffL]

How do I copy a sheet from one workbook to another workbook including all the formatting (column widths, boarders, and background colours etc).

Copying and pasteing the contents is easy but I want to bring acros all the formating

[EarnestAl]

Have both the donor and the recipient (unless you want a new spreadsheet) spreadsheets open.

1. In the donor spreadsheet, right click on the sheet tab at the bottom and select Move or copy sheet
2. In the dialogue under To document select the recipient spreadsheet, then select a position for it and a name for the copied sheet then click Copy button
   

[geoffL]

Hello @EarnestAl

Many thanks for your prompt ans clear reply.
This has saved me hours of work.
I never knew that this brilliant option already exiisted in the sheet tab.

Thanks again and kind regards.