I'm not sure how to go about this. I want populate a work schedule wit
tasks based on availablity, need, and trained criteria.

Let's say someone is needed to work in task ABC from the hours of 8a
to 10 pm. This person must also be trained in ABC to qualify and mus
be working a shift in that range to be scheduled.

So if Employee 1 works 9am to 5pm and is trained in ABC, a range o
cells in Employees1's row should read "ABC" "ABC" etc. in 20 min tim
intervals, until his shift ends or the need for the shift ends.

So I guess the code will have multiple conditions to satisfy befor
populating the cells with the appropriate task. There are multipl
tasks and multiple employees. If the need for the task becomes 0 or th
employee's shift has ended, the code should loop to the next cell, an
so on.

I'd like to set this up properly but am unsure how to do it.
Thanks!:confused

--
Message posted from http://www.ExcelForum.com