Hello guys, I need help creating a VBA for scheduling.
I am responsible for making work schedules for the volunteers in my church. To make it easy, here is a screenshot of the mock schedule format:
Let me explain the schedule to you.
- So the schedule is for every week starting from the 2nd week of September to the 3rd week of October.
- For every Friday we only need 1 volunteer
- For every Saturday we need 2 volunteers
- For every Sunday we need 3 volunteers
So I want the “Create Schedule“ button to autofill the work schedule
The rules for this schedule are:
1. Volunteers can only work once in a week
2. The minimum working time of each volunteer in a month is 1 and the maximum working time in a month is 2
3. However, in those 2 months, each volunteer can only work a maximum of 3 times (not 4).
4. If possible, volunteers should not work 2 weeks in a row (they need a break of at least 1 week after work)
5. Volunteers can work a maximum of once on a Friday for this 2 month
6. Likewise for Saturday, volunteers can work a maximum of once on Saturday in this 2 month
7. Exception on Sunday, because Sunday always requires more people, so volunteers can work a maximum of twice on Sunday in this 2 month
8. However, if possible, the second time they work on a Sunday should not be in the same month. That means, if the volunteer need to work twice on a Sunday, then they cannot work on a Sunday in the 4th week of September if they have already worked on a Sunday in the 2nd or 3rd Sunday of September.
I hope my explanation is easy to understand
Thank you in advance!
I am responsible for making work schedules for the volunteers in my church. To make it easy, here is a screenshot of the mock schedule format:
Let me explain the schedule to you.
- So the schedule is for every week starting from the 2nd week of September to the 3rd week of October.
- For every Friday we only need 1 volunteer
- For every Saturday we need 2 volunteers
- For every Sunday we need 3 volunteers
So I want the “Create Schedule“ button to autofill the work schedule
The rules for this schedule are:
1. Volunteers can only work once in a week
2. The minimum working time of each volunteer in a month is 1 and the maximum working time in a month is 2
3. However, in those 2 months, each volunteer can only work a maximum of 3 times (not 4).
4. If possible, volunteers should not work 2 weeks in a row (they need a break of at least 1 week after work)
5. Volunteers can work a maximum of once on a Friday for this 2 month
6. Likewise for Saturday, volunteers can work a maximum of once on Saturday in this 2 month
7. Exception on Sunday, because Sunday always requires more people, so volunteers can work a maximum of twice on Sunday in this 2 month
8. However, if possible, the second time they work on a Sunday should not be in the same month. That means, if the volunteer need to work twice on a Sunday, then they cannot work on a Sunday in the 4th week of September if they have already worked on a Sunday in the 2nd or 3rd Sunday of September.
I hope my explanation is easy to understand
Thank you in advance!
