The title makes this sound simple enough but my problem is that the source information is live (shared through Office 365) and also formatted in a way that makes it tricky to combine.
I have tried to get the people I work with used to a format that doesn't have date headers but they found this confusing.
So my hope is that you clever people might have a suggestion for making the process of combining two sheets that can't be reformatted a little easier than reformatting copies of the sheets!
Sheet 1
Sheet 2
I have tried to get the people I work with used to a format that doesn't have date headers but they found this confusing.
So my hope is that you clever people might have a suggestion for making the process of combining two sheets that can't be reformatted a little easier than reformatting copies of the sheets!
Sheet 1
Combo Roster.xlsx | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Roster 2 - June 2022 | |||||
2 | Site | ID | Manager | Support Person | ||
3 | WEEK 1 | |||||
4 | Wednesday 1/06/2022 | |||||
5 | India | 229373 | Norm | |||
6 | Australia | 229374 | Ben | |||
7 | America | 229375 | John | |||
8 | India | 229376 | Darryl | |||
9 | England | 229377 | Graham | |||
10 | Indonesia | |||||
11 | Wales | 229375 | John | |||
12 | Indonesia | 229378 | Ian | Josie | ||
13 | Indonesia | 229379 | Peter | Joan | ||
14 | Portugal | 229380 | Kevin | |||
15 | England | 229374 | Kerry | |||
16 | England | 229373 | Norm | |||
17 | Friday 3/06/2022 | |||||
18 | America | 229377 | Peter | |||
19 | England | 229374 | Mark | |||
20 | Mexico | 229379 | Lyn | |||
21 | WEEK 2 | |||||
22 | Monday 6/06/2022 | |||||
23 | America | 229381 | Janet | |||
24 | Wales | 229374 | Peter | |||
25 | Portugal | 229380 | Sam | |||
26 | Tuesday 7/06/2022 | |||||
27 | Greece | 229379 | Darryl | |||
28 | Wales | 229373 | David | |||
29 | England | 229374 | Graham | |||
30 | England | 229377 | Sam | |||
31 | Wednesday 8/06/2022 | |||||
32 | India | 229373 | Norm | |||
33 | Denmark | 229379 | Lyn | Lyn | ||
34 | Denmark | 229378 | Ian | Josie | ||
35 | America | 229379 | John | |||
36 | England | 229381 | Graham | |||
37 | Brazil | 229381 | Janet | |||
38 | India | 229382 | Darryl | |||
39 | Indonesia | |||||
40 | Wales | 229375 | John | |||
41 | France | 229378 | Bob | Ian | ||
42 | France | 229379 | Allan | Rob | ||
43 | Portugal | 229380 | Kevin | |||
44 | England | 229374 | Kerry | |||
45 | England | 229377 | Norm | |||
46 | Friday 10/06/2022 | |||||
47 | Ireland | 229375 | David | |||
48 | America | 229374 | Peter | |||
49 | England | 229374 | Mark | |||
50 | New Zealand | 229379 | John | |||
51 | Mexico | 229379 | Lyn | |||
52 | WEEK 3 | |||||
53 | Monday 13/06/2022 | |||||
54 | Public Holiday | |||||
55 | ||||||
56 | ||||||
57 | ||||||
58 | Tuesday 14/06/2022 | |||||
59 | Greece | 229379 | Darryl | |||
60 | Wales | 229373 | David | |||
61 | England | 229374 | Graham | |||
62 | England | 229377 | Sam | |||
63 | Wednesday 15/06/2022 | |||||
64 | India | 229373 | Norm | |||
65 | America | 229375 | John | |||
66 | England | 229374 | Graham | |||
67 | England | 229377 | Ben | |||
68 | India | 229382 | Darryl | |||
69 | Fiji | 229374 | Kerry | |||
70 | Indonesia | |||||
71 | Wales | 229375 | John | |||
72 | Indonesia | 229383 | Ann | Josie | ||
73 | Indonesia | 229379 | Peter | Joan | ||
74 | Portugal | 229380 | Kevin | |||
75 | England | 229374 | Kerry | |||
76 | England | 229377 | Norm | |||
77 | Friday 17/06/2022 | |||||
78 | America | 229377 | Peter | |||
79 | England | 229374 | Mark | |||
80 | New Zealand | 229375 | John | |||
81 | Mexico | 229379 | Lyn | |||
82 | WEEK 4 | |||||
83 | Monday 20/06/2022 | |||||
84 | America | 229381 | Janet | |||
85 | Wales | 229374 | Ken | |||
86 | Wales | 229377 | Peter | |||
87 | Portugal | 229380 | Sam | |||
88 | Tuesday 21/06/2022 | |||||
89 | Greece | 229379 | Darryl | |||
90 | Wales | 229373 | David | |||
91 | England | 229374 | Graham | |||
92 | England | 229377 | Sam | |||
93 | Wednesday 22/06/2022 | |||||
94 | Denmark | 229379 | Lyn | Pat | ||
95 | Denmark | 229383 | Ian | Josie | ||
96 | India | 229373 | Norm | |||
97 | America | 229375 | John | |||
98 | England | 229374 | Graham | |||
99 | India | 229382 | Darryl | |||
100 | England | 229377 | Janet | |||
101 | Indonesia | |||||
102 | Wales | 229375 | John | |||
103 | France | 229383 | Bob | Ian | ||
104 | France | 229379 | Allan | Rob | ||
105 | Portugal | 229380 | Kevin | |||
106 | England | 229374 | Kerry | |||
107 | England | 229377 | Norm | |||
108 | Friday 24/06/2022 | |||||
109 | America | 229377 | Peter | |||
110 | England | 229374 | Mark | |||
111 | New Zealand | 229375 | John | |||
112 | Mexico | 229379 | Lyn | |||
113 | WEEK 5 | |||||
114 | Monday 27/06/2022 | |||||
115 | America | 229381 | Janet | |||
116 | Thailand | 229379 | Ken | |||
117 | Wales | 229374 | Peter | |||
118 | Portugal | 229380 | Sam | |||
119 | Ukraine | 229375 | John | |||
120 | Tuesday 28/06/2022 | |||||
121 | Greece | 229379 | Darryl | |||
122 | Wales | 229373 | David | |||
123 | England | 229374 | Graham | |||
124 | England | 229377 | Sam | |||
125 | Wednesday 29/06/2022 | |||||
126 | India | 229373 | Norm | |||
127 | America | 229375 | John | |||
128 | England | 229374 | Graham | |||
129 | England | 229377 | Ben | |||
130 | Indonesia | |||||
131 | Wales | 229375 | John | |||
132 | Denmark | 229381 | Ken | |||
133 | Indonesia | 229383 | Ann | Josie | ||
134 | Indonesia | 229379 | Peter | Joan | ||
135 | Portugal | 229380 | Kevin | |||
136 | England | 229374 | Kerry | |||
137 | England | 229377 | Norm | |||
138 | Friday 1/07/2022 | |||||
139 | America | 229377 | Peter | |||
140 | New Zealand | 229375 | John | |||
141 | England | 229374 | Mark | |||
142 | Mexico | 229379 | Lyn | |||
2 - June 2022 |
Sheet 2
Combo Roster.xlsx | |||||
---|---|---|---|---|---|
A | B | C | |||
1 | Roster 1 - June 2022 | ||||
2 | Site | Manager | Support Person | ||
3 | WEEK 1 | ||||
4 | Monday 30/5/2022 | ||||
5 | North | NA | NA | ||
6 | Central | Nick | Jeanette | ||
7 | South | Harry | Margaret | ||
8 | Health | John | Barry | ||
9 | Project | Charlie | |||
10 | Tuesday 31/5/2022 | ||||
11 | North | NA | NA | ||
12 | Central | Glenn | Nick | ||
13 | South | - | ? | ||
14 | Health | Charlie | Barry | ||
15 | Project | Don | |||
16 | Wednesday 1/6/2022 | ||||
17 | North | NA | NA | ||
18 | Central | Danny | Sandra | ||
19 | South | Harry | Les | ||
20 | Health | Will | Mark | ||
21 | Wollongong | Phil | Doug | ||
22 | Project | Charlie | |||
23 | Thursday 2/6/2022 | ||||
24 | North | Glenn | Tony | ||
25 | Central | Danny | Gail | ||
26 | South | Harry | Kevin | ||
27 | Health | Will | Mark | ||
28 | Skoda | Charlie | |||
29 | Friday 3/6/2022 | ||||
30 | North | Phil | James | ||
31 | Central | Nick | Doug | ||
32 | South | Harry | Steve | ||
33 | Health | - | ? | ||
34 | Project | Don | |||
35 | WEEK 2 | ||||
36 | Monday 6/6/2022 | ||||
37 | North | Kevin | Homer | ||
38 | Central | Steve | Jeanette | ||
39 | South | - | - | ||
40 | Health | John | Barry | ||
41 | Project | Nick | |||
42 | Tuesday 7/6/2022 | ||||
43 | North | Doug | Bruce | ||
44 | Central | Glenn | Nick | ||
45 | South | ? | ? | ||
46 | Health | Ian | Barry | ||
47 | Project | Don | |||
48 | Wednesday 8/6/2022 | ||||
49 | North | Peter | Karen | ||
50 | Central | Danny | Sandra | ||
51 | South | - | - | ||
52 | Health | Will | Mark | ||
53 | Lucia's Car | Mary | Roy | ||
54 | Project | Charlie | |||
55 | Thursday 9/6/2022 | ||||
56 | North | Glenn | Tony | ||
57 | Central | Danny | Gail | ||
58 | South | - | - | ||
59 | Health | Will | Mark | ||
60 | Project | Wendy | |||
61 | Friday 10/6/2022 | ||||
62 | North | Phil | James | ||
63 | Central | Mary | Doug | ||
64 | South | Harry | Nick | ||
65 | Health | ? | ? | ||
66 | Project | Charlie | |||
67 | WEEK 3 | ||||
68 | Monday 13/6/2022 | ||||
69 | North | Kevin | Homer | ||
70 | Central | Nick | Jeanette | ||
71 | South | Harry | Margaret | ||
72 | Health | John | Barry | ||
73 | Project | Charlie | |||
74 | Tuesday 14/6/2022 | ||||
75 | North | Phil | Bruce | ||
76 | Central | Glenn | Nick | ||
77 | South | ? | ? | ||
78 | Health | Ian | Barry | ||
79 | Wollongong | ||||
80 | Project | Don | |||
81 | Wednesday 15/6/2022 | ||||
82 | North | Phil | Karen | ||
83 | Central | Danny | Sandra | ||
84 | South | Ann | Les | ||
85 | Health | Will | Mark | ||
86 | Wollongong | Mary | Roy | ||
87 | Project | Charlie | |||
88 | Thursday 16/6/2022 | ||||
89 | North | Glenn | Tony | ||
90 | Central | Danny | Gail | ||
91 | South | Harry | Kevin | ||
92 | Health | Will | Mark | ||
93 | Project | Wendy | |||
94 | Friday 17/6/2022 | ||||
95 | North | Joe | James | ||
96 | Central | Mary | Doug | ||
97 | South | Harry | Steve | ||
98 | Health | Charlie | ? | ||
99 | Project | Don | |||
100 | WEEK 4 | ||||
101 | Monday 20/6/2022 | ||||
102 | North | Kevin | Homer | ||
103 | Central | Nick | Jeanette | ||
104 | South | Harry | Margaret | ||
105 | Health | John | Barry | ||
106 | Project | Charlie | |||
107 | Tuesday 21/6/2022 | ||||
108 | North | Phil | Bruce | ||
109 | Central | Glenn | Nick | ||
110 | South | ? | ? | ||
111 | Health | Ian | Barry | ||
112 | Project | Don | |||
113 | Wednesday 22/6/2022 | ||||
114 | North | Phil | Karen | ||
115 | Central | Danny | Sandra | ||
116 | South | Ann | Les | ||
117 | Health | Will | Mark | ||
118 | Wollongong | Mary | Roy | ||
119 | Project | Charlie | |||
120 | Thursday 23/6/2022 | ||||
121 | North | Glenn | Tony | ||
122 | Central | Danny | Gail | ||
123 | South | Harry | Kevin | ||
124 | Health | Will | Mark | ||
125 | Project | Wendy | |||
126 | Friday 24/6/2022 | ||||
127 | North | Joe | James | ||
128 | Central | Mary | Doug | ||
129 | South | Harry | Steve | ||
130 | Health | Charlie | ? | ||
131 | Project | Don | |||
132 | WEEK 5 | ||||
133 | Monday 27/6/2022 | ||||
134 | North | Kevin | Homer | ||
135 | Central | Nick | Jeanette | ||
136 | South | Harry | Margaret | ||
137 | Health | John | Barry | ||
138 | Project | Charlie | |||
139 | Tuesday 28/6/2022 | ||||
140 | North | Phil | Bruce | ||
141 | Central | Glenn | Nick | ||
142 | South | ? | ? | ||
143 | Health | Ian | Barry | ||
144 | Project | Don | |||
145 | Wednesday 29/6/2022 | ||||
146 | North | Phil | Karen | ||
147 | Central | Danny | Sandra | ||
148 | South | Ann | Les | ||
149 | Health | Will | Mark | ||
150 | Wollongong | Mary | Roy | ||
151 | Project | Charlie | |||
152 | Thursday 30/6/2022 | ||||
153 | North | Glenn | Tony | ||
154 | Central | Danny | Gail | ||
155 | South | Harry | Kevin | ||
156 | Health | Will | Mark | ||
157 | Project | Wendy | |||
158 | Friday 1/07/2022 | ||||
159 | North | Joe | James | ||
160 | Central | Mary | Doug | ||
161 | South | Harry | Steve | ||
162 | Health | Charlie | ? | ||
163 | Project | ? | |||
1 - June 2022 |