Auto-populate 15-minute intervals based on drop down.

[pskra]

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

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