Copy Sheet Format to Multiple Sheets

[unknownymous]

Hi Guys,

I've made research about this but can't find the right one. So I have this excel sheet named "Subject" with multiple sheets (sheet A to D). What I need is to find the codes wherein the macro will copy the entire format of Sheet A to Sheet B,C & D.

Any help will be much appreciated.

 

[My Aswer Is This]

You said:
So I have this excel

sheet ​

named "Subject" with multiple sheets (sheet A to D).

Do would mean you have a Workbook named "Subject"

Why not just make a copy of Worksheet A ?

This worksheet A would be know as a Template

It is all setup the way you want with all your formatting and standard data.
Then when you want to make a exact copy with all your formatting and standard data you make a copy of the template and give it a new name.​

 

[unknownymous]

My bad.. yup I have a Workbook with Filename: Subject and it has multiple sheets in it. I want to use the sheet A's format across the other sheets as other sheets don't match with Sheet A's format). Thanks!

 

[My Aswer Is This]

Yes I understand:

I want to use the sheet A's format across the other sheets as other sheets don't match with Sheet A's format). Thanks!​

I gave a few suggestions like just make copies of sheet A
And is this really the sheet name Sheet name A.
I would give my sheet a better name. Like maybe MasterCopy
Do the other sheets already have data in them?

I really do not know how to copy all the formatting from one sheet and paste just the formatting into another sheet.

And what exactly do you mean by formatting.
Do you mean headers, column Width each cells font size etc. etc.

So I assume you read my previous post and do not like the ideals I had.