Hi all,
I am trying to create an automatic scheduler which takes into account role priority, staff priority within that role, and staff availability. Currently, I have a table to show the priority level of the role and the minimum staff members required to cover. I then have a seperate table showing the allocation priority of staff members for each department and an availability calendar to show if a staff member is available on each date.
What I am trying to achieve is to create a table for the following 2 weeks to show which staff members should be allocated to each role. For example:
The schedule for 1st January would look at the role priority table and see that Role 2 is the top priority. It would then allocate the highest priority staff member (in this case, Staff 5) to the schedule. If Staff 5 was marked as unavailable on the calendar, then it would move on to the second priority staff member etc.
I am guessing that this will require some VBA? I am hoping that somebody has done something similar in the past and can guide me in the correct direction to achieve this.
I am trying to create an automatic scheduler which takes into account role priority, staff priority within that role, and staff availability. Currently, I have a table to show the priority level of the role and the minimum staff members required to cover. I then have a seperate table showing the allocation priority of staff members for each department and an availability calendar to show if a staff member is available on each date.
What I am trying to achieve is to create a table for the following 2 weeks to show which staff members should be allocated to each role. For example:
The schedule for 1st January would look at the role priority table and see that Role 2 is the top priority. It would then allocate the highest priority staff member (in this case, Staff 5) to the schedule. If Staff 5 was marked as unavailable on the calendar, then it would move on to the second priority staff member etc.
I am guessing that this will require some VBA? I am hoping that somebody has done something similar in the past and can guide me in the correct direction to achieve this.
