CallMeKris
New Member
- Joined
- Feb 3, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
Hello!
I'm trying to set up a monthly sign up sheet for my work. The people who will be using it have a tendency to break excel files so I want to keep what they can do limited to just selecting options from drop down menus. On the weekly tables, they will select their name from the list for which day and time works for them and what I want to happen is the date and time slot they chose to then be displayed in the blue table. I've tried a few various IF formulas but I'm no pro by any means and all my googling hasn't gotten me anywhere.
If this is even possible, I'd appreciate any advice. If not, then I appreciate the assistance none the less!
I'm trying to set up a monthly sign up sheet for my work. The people who will be using it have a tendency to break excel files so I want to keep what they can do limited to just selecting options from drop down menus. On the weekly tables, they will select their name from the list for which day and time works for them and what I want to happen is the date and time slot they chose to then be displayed in the blue table. I've tried a few various IF formulas but I'm no pro by any means and all my googling hasn't gotten me anywhere.
If this is even possible, I'd appreciate any advice. If not, then I appreciate the assistance none the less!
Slot Sign Up.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | |||
5 | 2-Mar | 3-Mar | 4-Mar | 5-Mar | 6-Mar | 2-Mar | 3-Mar | 4-Mar | 5-Mar | 6-Mar | |||||||||||
6 | TLS | Task | Date | Time Slot | Completed | Times | Monday | Tuesday | Wednesday | Thursday | Friday | Times | Monday | Tuesday | Wednesday | Thursday | Friday | ||||
7 | Name 1 | 3/2 | 11:00AM | 11:00AM | |||||||||||||||||
8 | Name 2 | 11:30AM | Name 1 | 11:30AM | |||||||||||||||||
9 | Name 3 | 12:00PM | 12:00PM | ||||||||||||||||||
10 | Name 4 | 12:30PM | 12:30PM | ||||||||||||||||||
11 | Name 5 | 1:00PM | 1:00PM | ||||||||||||||||||
12 | Name 6 | ||||||||||||||||||||
13 | Name 7 | 2:00PM | 2:00PM | ||||||||||||||||||
14 | Name 8 | 2:30PM | 2:30PM | ||||||||||||||||||
15 | Name 9 | 3:00PM | 3:00PM | ||||||||||||||||||
16 | Name 10 | 3:30PM | 3:30PM | ||||||||||||||||||
17 | Name 11 | 4:00PM | 4:00PM | ||||||||||||||||||
18 | Name 12 | 4:30PM | 4:30PM | ||||||||||||||||||
19 | Name 13 | 5:00PM | 5:00PM | ||||||||||||||||||
20 | 5:30PM | 5:30PM | |||||||||||||||||||
21 | |||||||||||||||||||||
22 | 2-Mar | 3-Mar | 4-Mar | 5-Mar | 6-Mar | 2-Mar | 3-Mar | 4-Mar | 5-Mar | 6-Mar | |||||||||||
23 | Times | Monday | Tuesday | Wednesday | Thursday | Friday | Times | Monday | Tuesday | Wednesday | Thursday | Friday | |||||||||
24 | 11:00AM | 11:00AM | |||||||||||||||||||
25 | 11:30AM | 11:30AM | |||||||||||||||||||
26 | 12:00PM | 12:00PM | |||||||||||||||||||
27 | 12:30PM | 12:30PM | |||||||||||||||||||
28 | |||||||||||||||||||||
29 | 2:00PM | 2:00PM | |||||||||||||||||||
30 | 2:30PM | 2:30PM | |||||||||||||||||||
31 | 3:00PM | 3:00PM | |||||||||||||||||||
32 | 3:30PM | 3:30PM | |||||||||||||||||||
33 | 4:00PM | 4:00PM | |||||||||||||||||||
34 | 4:30PM | 4:30PM | |||||||||||||||||||
35 | 5:00PM | 5:00PM | |||||||||||||||||||
36 | 5:30PM | 5:30PM | |||||||||||||||||||
37 | |||||||||||||||||||||
38 | 2-Mar | 3-Mar | 4-Mar | 5-Mar | 6-Mar | ||||||||||||||||
39 | Times | Monday | Tuesday | Wednesday | Thursday | Friday | |||||||||||||||
40 | 11:00AM | ||||||||||||||||||||
41 | 11:30AM | ||||||||||||||||||||
42 | 12:00PM | ||||||||||||||||||||
43 | 12:30PM | ||||||||||||||||||||
44 | |||||||||||||||||||||
45 | 2:00PM | ||||||||||||||||||||
46 | 2:30PM | ||||||||||||||||||||
47 | 3:00PM | ||||||||||||||||||||
48 | 3:30PM | ||||||||||||||||||||
49 | 4:00PM | ||||||||||||||||||||
50 | 4:30PM | ||||||||||||||||||||
51 | 5:00PM | ||||||||||||||||||||
52 | 5:30PM | ||||||||||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D7 | D7 | =IF(COUNTIF(I7:I20,"*Name 1*"),I5,"") |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
I7:M11 | List | =$B$7:$B$19 |
I13:M20 | List | =$B$7:$B$19 |
P7:T11 | List | =$B$7:$B$19 |
P13:T20 | List | =$B$7:$B$19 |
P24:T27 | List | =$B$7:$B$19 |
P29:T36 | List | =$B$7:$B$19 |
I24:M27 | List | =$B$7:$B$19 |
I29:M36 | List | =$B$7:$B$19 |
I40:M43 | List | =$B$7:$B$19 |
I45:M52 | List | =$B$7:$B$19 |