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 | |||||
