The ranking system would allow me to rank my better employees to get th
most hours that their availablilty would allow. The time of th
scheduled shifts would vary depending on the employees availabilty.
There are three shifts, open, mid and closing. The schedule needs t
be done weekly and specific tasks are assigned in another workbook tha
is filled out daily. I have the ranking system figured out and th
availability. I just need to know how to write a macro that wil
compare availability to the ranking system and then fill out th
schedule using only the number of hours available and still filling
set requirement of filling the number of needed employeesper shif
depending on the day. I know it is extremly complex and for a macr
newbie like myself, its like asking one man to move a mountain. Thi
is the way I learn this stuff though, accept a task to build somthin
like this, research how to do it (ask the experts) and then study WH
there answer works thus learning how to think of my own solutions fo
future projects.
Thanks,
Kingtrito

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