Streamline workbook

DrRandyman · 2023-04-05T22:48:48+01:00

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

DrRandyman
Apr 5th 2023

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

Carim

OzMVP (007*2) - 4
Reactions Received

1,149

Points

39,864

Trophies

1

Posts

7,718

Operating System

Windows (x64)

Excel Version

Excel 2019
Apr 27th 2023
- #41
You are welcome
If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner
- 1
- 2
- 3Page 3 of 3

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Facebook
Twitter
Reddit
WhatsApp
LinkedIn
Pinterest
XING

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

Participate now!

Share