Hello,
First time post here, I did try looking up but either this hasn't been discussed or I'm not using the correct terms.
What I'm trying to achieve is having a spreadsheet that would auto-populate, based on one drop down entry. For example - entering code 3 in a cell would also populate the next cell with a 3. Time is split in 15 minute intervals and based on activities, some take 1 interval, some 2 intervals and then the lunch break takes 4 intervals. An example is attached, is this achievable either through any formula or VBA even?
Thanks
First time post here, I did try looking up but either this hasn't been discussed or I'm not using the correct terms.
What I'm trying to achieve is having a spreadsheet that would auto-populate, based on one drop down entry. For example - entering code 3 in a cell would also populate the next cell with a 3. Time is split in 15 minute intervals and based on activities, some take 1 interval, some 2 intervals and then the lunch break takes 4 intervals. An example is attached, is this achievable either through any formula or VBA even?
Thanks
Breaks draft.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |||
1 | 7:00 | 8:00 | 9:00 | 10:00 | |||||||||||||||||
2 | Shift | Moderator | Emp ID | 7:00 | 7:15 | 7:30 | 7:45 | 8:00 | 8:15 | 8:30 | 8:45 | 9:00 | 9:15 | 9:30 | 9:45 | 10:00 | 10:15 | 10:30 | 10:45 | ||
3 | Morning Shift: 7:00 - 16:00 | Agent 1 | 1 | ||||||||||||||||||
4 | Agent 2 | 4 | 4 | 4 | 4 | ||||||||||||||||
5 | Agent 3 | 2 | 2 | ||||||||||||||||||
6 | Agent 4 | 3 | 3 | ||||||||||||||||||
7 | Agent 5 | 5 | 5 | ||||||||||||||||||
8 | Agent 6 | 7 | 7 | ||||||||||||||||||
9 | 6 | 6 | |||||||||||||||||||
10 | 4 | 4 | 4 | 4 | |||||||||||||||||
11 | |||||||||||||||||||||
12 | |||||||||||||||||||||
13 | |||||||||||||||||||||
14 | |||||||||||||||||||||
15 | Legend | 0:00 | 0:15 | 0:30 | 0:45 | ||||||||||||||||
16 | Activity1 | 1 | 1 | ||||||||||||||||||
17 | Activity2 | 2 | 2 | 2 | |||||||||||||||||
18 | Activity3 | 3 | 3 | 3 | |||||||||||||||||
19 | Activity4 | 4 | 4 | 4 | 4 | 4 | |||||||||||||||
20 | Activity5 | 5 | 5 | 5 | |||||||||||||||||
21 | Activity6 | 6 | 6 | 6 | |||||||||||||||||
22 | Activity7 | 7 | 7 | 7 | |||||||||||||||||
Template R2 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
D3:S10 | List | =$C$16:$C$22 |