Thank you- this meets the need. I think I understand what you've done and am
adapting it to our spreadsheet. Thank you also for the references you
included at the top- very helpful as well.

JJ

"Ed Ferrero" wrote:

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