Copying blank table to all sheets with several exceptions

[ManateeProfanity]

Hi guys,

I'd like to copy the same blank table format to all sheets in a workbook except sheets named 'Frozen' 'Dry' 'Fresh' 'Utensils and Packaging' 'Cleaning' 'Uniform' 'First Aid' 'Warehouse Usage' 'F&F' 'Racking 1ST person' I'm assuming this would have to be done with VBA? Cheers

[Keebellah]

You have provided the answer yourself, you say copy the table to all worksheets except .... and yes you will need VBA to do that.
The solution is simple, start the macro recorder and do it for one sheet, you select the table and copy it it to the worksheet you want. stop the macro recorder.
Read the generated VBA code and the edit it to loop though all the available worksheets and if the worksheet's name is not one of the 'exceptions' paste the table etc.

The loop for the worksheets is something like

Please Login or Register  to view this content.

You must however add checks to avoid tha worksheet that already contains the table and well ... try it out.
If you have the recorded macro you can also attach that code and see if we can help from there or attach the file

[ManateeProfanity]

Thanks very much!