>I have an excel spreadsheet which is created from a template with column headers and formatting
>
>when I add a new sheet i need to have this same formatting
>
>can this be done or do i need to recreate it with automation code on every sheet
>
>there could be hundreds of sheets
>
>
>Peter

If you have a template, then you can copy a particular sheet to another workbook.

Best Wishes