Attached are 2 excel sheets.
The sheet names "Proj_Resources" has a summary sheet. Infact i got macro for that done in this forum itself.
All i am looking at is the summary sheet to be formatted as the way i want (which you can find a format in "Sheet2" attached)
Thanks in Advance
Max