I need a 4th sheet to be added to each workbook that is created use macro coding

[sonu_kumar444]

I have posted this question earlier in this thread - "http://www.excelforum.com/excel-prog...-one-time.html" which has been solved. However, i need an enhancement to this code

I need a 4th sheet to be added to each workbook that is created. The sheetname should be "DETAIL" and it should be the 1st in the list of sheets. So the order of the sheets should be DETAIL / EXCHANGE/ CORPORATE /LOYALTY.
This sheet should have a particular format which should be replicated to all other files. I do not need anything else to be done to the DETAIL sheet, except the format. If i need to put any dealer-wise info into that sheet, i will do so myself.

The format of this sheet keeps changing, hence i didnt think of including it in my original thread. But, today i realised that if i dont have the data, it doesnt matter. Atleast i can create the format.

I have attached the format of the output sheet that i require.

[arlu1201]

Sonu,

Can you please attach your result sheet without the zip? I have an issue with zip files in my system and am not able to open your file.

[arlu1201]

Updated code -

Please Login or Register  to view this content.