Automatic shift scheduler

[carblo]

Hi

I want to create an automatic shift scheduler in Excel. I've included an example sheet. Basically I would like to create a table each month to schedule shifts for the employees. For each day there is a required number of employees (usually 4 but it can vary) and a maximum number of shifts for each employee per month. Also included in the table are the days certain employees aren't able to work (marked with an "X"). What I would need is Excel to fill out the table based on that criteria. If there are not enough employees with enough shifts to fill out the month, then I'd like it to just leave those cells empty.

Any help would be appreciated

Thank you!