Pulling hair out to figure out how to make this all come together:
Variable number of employees depending on which office is using the sheet.
One person scheduled for duty each day, Monday through Friday, except holidays.
What I am trying to do, is list available people and Excel will simply assign a duty day, starting at the top and rotating through. When finished, it will start over.
The exception would be if that person is on vacation or off.
I have been playing with each day the sheet will look at the list of employees, compare to a list of people on vacation & people that have just served on duty and make a list of "available for duty". Then take the next on list.
I think I am making a mountain out of a molehill.
Can anyone suggest a better way?
If wanted/needed, I can post my worksheet, but it really is a nonsensical mess right now. I am starting over.
Bookmarks