shift scheduling format needed in excel

Hi friends

i have an employee data for shift scheduling
which should work automatically.
i need this data in special format which i have shown in attached excel file

pls help

regards
Killerware

AttachmentSize
excel2.xls43 KB

excel formatting

check this link it will help you t format excel page from VBA

http://csharp.net-informations.com/excel/csharp-format-excel.htm

craig.