Scheduling staff to tasks based on seniority
 

Hello,

I need to create a spreadsheet which assigns staff to specific roles
and shift times. The staff are allocated on a seniority basis. The
most senior person is aligned to his/her first choice of shift/task,
then it moves to the next person. So far I have listed all staff and
their seniority and added five choices for each person. I need to run
a macro/code to assign the staff, and check to ensure that once the
shift/task is full, the shift/task is closed off. The shift/task
choice is a a simple code (i.e. A2 means shift A task 2). Can anyone
help me?


yours hopefully,


Matt