Automated Task Scheduler During Time Blocks - VBA

[khakistatistic1]

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.

	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>