I run a report giving me the shift patterns of colleagues.
I need to break down what shift pattern they are on so forexample we have the following. So in the 1st columns I have in A 1and then in B & C I have those starting 1 then 2 in B and in C will bethose starting on 2 then 1 and then the 3 more for those on rotation 3.
Rotation 1 – standard Mon – Fri (
Rotation 2 – those who start their shift pattern this weekand those who started last week.
Rotation 3 ect.
So my requirement is that I need to put an identifier nextto the colleague to determine the column they will allocated to.
[TABLE="width: 397"]
<tbody>[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 68, bgcolor: transparent"] [/TD]
[TD="width: 63, bgcolor: transparent"] [/TD]
[TD="width: 75, bgcolor: transparent"] [/TD]
[TD="width: 103"] [/TD]
[/TR]
</tbody>[/TABLE]
Not sue what the best option would be formula or VBA?
I need to break down what shift pattern they are on so forexample we have the following. So in the 1st columns I have in A 1and then in B & C I have those starting 1 then 2 in B and in C will bethose starting on 2 then 1 and then the 3 more for those on rotation 3.
Rotation 1 – standard Mon – Fri (
Rotation 2 – those who start their shift pattern this weekand those who started last week.
Rotation 3 ect.
So my requirement is that I need to put an identifier nextto the colleague to determine the column they will allocated to.
[TABLE="width: 397"]
<tbody>[TR]
[TD="width: 67, bgcolor: transparent"]
Rotations
[TD="width: 75, bgcolor: transparent"]
Shift Date
[TD="width: 80, bgcolor: transparent"]
Shift Day
[TD="width: 68, bgcolor: transparent"]
Shift Start
[TD="width: 63, bgcolor: transparent"]
Shift End
[TD="width: 75, bgcolor: transparent"]
Shift Hours
[TD="width: 103"]
Shift Pattern ID
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
1
[TD="width: 75, bgcolor: transparent"]
26/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
09:00
[TD="width: 63, bgcolor: transparent"]
17:00
[TD="width: 75, bgcolor: transparent"]
7
[TD="width: 103"]
1
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
1
[TD="width: 75, bgcolor: transparent"]
26/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
09:00
[TD="width: 63, bgcolor: transparent"]
17:00
[TD="width: 75, bgcolor: transparent"]
7
[TD="width: 103"]
1
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
1
[TD="width: 75, bgcolor: transparent"]
26/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
09:00
[TD="width: 63, bgcolor: transparent"]
17:00
[TD="width: 75, bgcolor: transparent"]
7
[TD="width: 103"]
1
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
3
[TD="width: 75, bgcolor: transparent"]
26/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
09:00
[TD="width: 63, bgcolor: transparent"]
17:30
[TD="width: 75, bgcolor: transparent"]
7.5
[TD="width: 103"]
4
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
2
[TD="width: 75, bgcolor: transparent"]
19/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
08:00
[TD="width: 63, bgcolor: transparent"]
16:30
[TD="width: 75, bgcolor: transparent"]
8
[TD="width: 103"]
3
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
2
[TD="width: 75, bgcolor: transparent"]
26/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
09:00
[TD="width: 63, bgcolor: transparent"]
17:30
[TD="width: 75, bgcolor: transparent"]
8
[TD="width: 103"]
2
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
1
[TD="width: 75, bgcolor: transparent"]
27/11/2018
[TD="width: 80, bgcolor: transparent"]
Tuesday
[TD="width: 68, bgcolor: transparent"]
07:45
[TD="width: 63, bgcolor: transparent"]
17:15
[TD="width: 75, bgcolor: transparent"]
9
[TD="width: 103"]
1
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
2
[TD="width: 75, bgcolor: transparent"]
19/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
07:00
[TD="width: 63, bgcolor: transparent"]
16:00
[TD="width: 75, bgcolor: transparent"]
8
[TD="width: 103"]
3
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
2
[TD="width: 75, bgcolor: transparent"]
19/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
08:30
[TD="width: 63, bgcolor: transparent"]
17:00
[TD="width: 75, bgcolor: transparent"]
7.75
[TD="width: 103"]
3
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
2
[TD="width: 75, bgcolor: transparent"]
26/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
08:15
[TD="width: 63, bgcolor: transparent"]
16:30
[TD="width: 75, bgcolor: transparent"]
7.75
[TD="width: 103"]
2
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
3
[TD="width: 75, bgcolor: transparent"]
12/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
08:00
[TD="width: 63, bgcolor: transparent"]
16:30
[TD="width: 75, bgcolor: transparent"]
7.5
[TD="width: 103"]
6
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
3
[TD="width: 75, bgcolor: transparent"]
13/11/2018
[TD="width: 80, bgcolor: transparent"]
Tuesday
[TD="width: 68, bgcolor: transparent"]
09:00
[TD="width: 63, bgcolor: transparent"]
17:30
[TD="width: 75, bgcolor: transparent"]
7.5
[TD="width: 103"]
6
[/TR]
[TR]
[TD="width: 67, bgcolor: transparent"]
3
[TD="width: 75, bgcolor: transparent"]
19/11/2018
[TD="width: 80, bgcolor: transparent"]
Monday
[TD="width: 68, bgcolor: transparent"]
09:00
[TD="width: 63, bgcolor: transparent"]
11:00
[TD="width: 75, bgcolor: transparent"]
2
[TD="width: 103"]
5
[/TR]
</tbody>[/TABLE]
Not sue what the best option would be formula or VBA?