Hello, I am hoping you can be of assistance to me.
The attached workbook is a schedule of church workers for both nursery and children’s church.
On the “Schedule” sheet, the range A1:C22 is what I have for Nursery workers and the dates they are scheduled.
E1:H22 is the range for Childrens church workers and the dates they are scheduled.
I2:N22 show the dates that some of them are not available.
A24:A33 are the names of the Nursery workers.
The “Data validation” sheet is my attempt at beginning the process, but I just don’t know where to go from there.
I would like to streamline this workbook in a couple of ways.
- To be able to select from a list of names of teachers and assistants (which sounds like it would be data validation)
- To keep from scheduling a person on a day that they indicate they are unavailable. (Maybe an error alert)
- To keep from giving someone double duty in both Nursery and Children’s church on the same day (Again, maybe using an error alert).
Any help you can give would be great.