VBA to Autofill a work/task schedule

[StevenP138]

I need to make a work schedule in a where different people are assigned tasks on different days of the week.



I would like to get any ideas on a way I can make a VBA that automatically fills out the blank days on the schedule while meeting these rules.



Only people that can preform the job are assigned to it.

If possible, a person only does one job a day.

If possible, a good rotation where you must do all the jobs.

If possible, a good mix of jobs that require multiple people.

• (example Task #1 requires 2 people on M/W/F and 1 on Tu/Th
• try to mix so you get an even number of chores on that task,
• not always stuck on M/W/F or Tu/Th

Here is my List of Tasks and Employees that can do them.

Here is an idea of where I'm heading for the schedule to look like. But open to any and all ideas.

I'm not sure where to begin with this so I wanted to get some input and tips on where I should start or if anyone has encountered something similar to this already written which I can modify. Can anyone help me?