Excel VBAHow to populate a new workboook with the existing formatting?

[xstyle00]

Hi,

I need to populate the 100 new workbooks with the same formatting (Header, color, combobox, fomular and etc.).

How to do that?

CheerZ
Xstyle

 

[SkipVought]

Hi,

How about SaveAs...???

Skip,

_[red][/red]

 

[xstyle00]

Thanks

The situation is not that simple.
I have designed my template which contains combo boxes, module and etc.

Now I have to populate my template with 100+ copies with same format but for different groups.

It means that each new workbook has to have same formatting (i.e. headings, column width, colour and etc.) but with different group name and other related feature (e.g. group code, FTE no., total expenditure, and etc.) according to the cost centre, which would be provided in the reference table.

I dont think Saveas would solve my problem.

Many thanks

 

[SkipVought]

Where is the Source Data?

What discriminates the groups?



Skip,

_[red][/red]