Hi JJ,
Although this can be done, it is a little hard to explain in a text message.
I have placed a sample file at
http://www.edferrero.com/ExcelCharts...2/Default.aspx
Look for 'Employee Roster' on page 3 of the samples.
Ed Ferrero
www.edferrero.com