I am trying to create a sign up sheet that has timeslots throughout the day. There are 46 available slots however I can only have 25 people sign up per day. Is there a way to create some formula to prevent a 26th person from signing up?
Times are in column A (6-51) text is in B,C, D for day 1: E, F, G for day 2: H, I, J for day 3.
<tbody>
</tbody>
I cannot have it as a macro. I appreciate any assistance.
Times are in column A (6-51) text is in B,C, D for day 1: E, F, G for day 2: H, I, J for day 3.
a | b | c | d | e | f | g | h | I | j | |
4 | ||||||||||
5 | Title | Last | First | Title | Last | First | Title | Last | First | |
6 | 8:30 | |||||||||
7 | 8:40 | |||||||||
8 | 8:50 | |||||||||
9 | 9:00 | |||||||||
10 | 9:10 | |||||||||
11 | 9:20 | |||||||||
12 | 9:30 | |||||||||
13 | 9:40 |
<tbody>
</tbody>
I cannot have it as a macro. I appreciate any assistance.