So, my wife is a restaurant manager and spends an inordinate amount of time creating server schedules. If possible, I would like to automate this for her so she wouldn't need to spend 4-6 hrs a week ...

If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 ...