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. Thank you, Randy
