khakistatistic1
New Member
- Joined
- Dec 14, 2015
- Messages
- 1
I am trying to create an automated duty scheduler that places people into time slots based upon their availability. Either through formulas or code I'll need something that allows me to click a "Generate" button and auto populate the below table with names. Once everyone is placed I need for everyone's total blocks of time to be as close to equal as possible for the week. I'll have their schedule availability on a separate sheet and will use it as a reference.
I'm not a stranger to Excel VBA - I'm a slightly less than moderately adept coder. I just need someone to point me in the right direction for a starting point.
<tbody>
</tbody>
I'm not a stranger to Excel VBA - I'm a slightly less than moderately adept coder. I just need someone to point me in the right direction for a starting point.
Sun | Mon | Tue | Wed | Thu | Fri | Sat | |
0700 | Jason | Jason | Todd | Alan | Todd | Brian | |
0800 | Jason | Jason | Todd | Alan | Todd | Brian | |
0900 | Jason | Jason | Frank | Frank | Brian | Jason | |
1000 | Frank | Frank | Brian | Jason | |||
1100 | Frank | Frank | |||||
1200 | |||||||
1300 | |||||||
1400 | |||||||
1500 | |||||||
1600 | |||||||
1700 | |||||||
1800 | |||||||
1900 | |||||||
2000 | |||||||
2100 | |||||||
2200 | |||||||
2300 | |||||||
2400 | |||||||
<tbody>
</tbody>