Combining Sheet Data

jstuexcel

New Member
Joined
Jun 14, 2022
Messages
6
Office Version
  1. 365
Platform
  1. Windows
  2. Web
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
Combo Roster.xlsx
ABCD
1Roster 2 - June 2022
2SiteIDManagerSupport Person
3WEEK 1
4Wednesday 1/06/2022
5India229373Norm
6Australia229374Ben
7America229375John
8India229376Darryl
9England229377Graham
10Indonesia
11Wales229375John
12Indonesia229378IanJosie
13Indonesia229379PeterJoan
14Portugal229380Kevin
15England229374Kerry
16England229373Norm
17Friday 3/06/2022
18America229377Peter
19England229374Mark
20Mexico229379Lyn
21WEEK 2
22Monday 6/06/2022
23America229381Janet
24Wales229374Peter
25Portugal229380Sam
26Tuesday 7/06/2022
27Greece229379Darryl
28Wales229373David
29England229374Graham
30England229377Sam
31Wednesday 8/06/2022
32India229373Norm
33Denmark229379LynLyn
34Denmark229378IanJosie
35America229379John
36England229381Graham
37Brazil229381Janet
38India229382Darryl
39Indonesia
40Wales229375John
41France229378BobIan
42France229379AllanRob
43Portugal229380Kevin
44England229374Kerry
45England229377Norm
46Friday 10/06/2022
47Ireland229375David
48America229374Peter
49England229374Mark
50New Zealand229379John
51Mexico229379Lyn
52WEEK 3
53Monday 13/06/2022
54Public Holiday
55
56
57
58Tuesday 14/06/2022
59Greece229379Darryl
60Wales229373David
61England229374Graham
62England229377Sam
63Wednesday 15/06/2022
64India229373Norm
65America229375John
66England229374Graham
67England229377Ben
68India229382Darryl
69Fiji229374Kerry
70Indonesia
71Wales229375John
72Indonesia229383AnnJosie
73Indonesia229379PeterJoan
74Portugal229380Kevin
75England229374Kerry
76England229377Norm
77Friday 17/06/2022
78America229377Peter
79England229374Mark
80New Zealand229375John
81Mexico229379Lyn
82WEEK 4
83Monday 20/06/2022
84America229381Janet
85Wales229374Ken
86Wales229377Peter
87Portugal229380Sam
88Tuesday 21/06/2022
89Greece229379Darryl
90Wales229373David
91England229374Graham
92England229377Sam
93Wednesday 22/06/2022
94Denmark229379LynPat
95Denmark229383IanJosie
96India229373Norm
97America229375John
98England229374Graham
99India229382Darryl
100England229377Janet
101Indonesia
102Wales229375John
103France229383BobIan
104France229379AllanRob
105Portugal229380Kevin
106England229374Kerry
107England229377Norm
108Friday 24/06/2022
109America229377Peter
110England229374Mark
111New Zealand229375John
112Mexico229379Lyn
113WEEK 5
114Monday 27/06/2022
115America229381Janet
116Thailand229379Ken
117Wales229374Peter
118Portugal229380Sam
119Ukraine229375John
120Tuesday 28/06/2022
121Greece229379Darryl
122Wales229373David
123England229374Graham
124England229377Sam
125Wednesday 29/06/2022
126India229373Norm
127America229375John
128England229374Graham
129England229377Ben
130Indonesia
131Wales229375John
132Denmark229381Ken
133Indonesia229383AnnJosie
134Indonesia229379PeterJoan
135Portugal229380Kevin
136England229374Kerry
137England229377Norm
138Friday 1/07/2022
139America229377Peter
140New Zealand229375John
141England229374Mark
142Mexico229379Lyn
2 - June 2022



Sheet 2
Combo Roster.xlsx
ABC
1Roster 1 - June 2022
2SiteManagerSupport Person
3WEEK 1
4Monday 30/5/2022
5North NANA
6Central NickJeanette
7South HarryMargaret
8Health JohnBarry
9ProjectCharlie
10Tuesday 31/5/2022
11North NANA
12Central GlennNick
13South -?
14Health CharlieBarry
15ProjectDon
16Wednesday 1/6/2022
17North NANA
18Central DannySandra
19South HarryLes
20Health WillMark
21Wollongong PhilDoug
22ProjectCharlie
23Thursday 2/6/2022
24North GlennTony
25Central DannyGail
26South HarryKevin
27Health WillMark
28SkodaCharlie
29Friday 3/6/2022
30North PhilJames
31Central NickDoug
32South HarrySteve
33Health -?
34ProjectDon
35WEEK 2
36Monday 6/6/2022
37North KevinHomer
38Central SteveJeanette
39South --
40Health JohnBarry
41ProjectNick
42Tuesday 7/6/2022
43North DougBruce
44Central GlennNick
45South ??
46Health IanBarry
47ProjectDon
48Wednesday 8/6/2022
49North PeterKaren
50Central DannySandra
51South --
52Health WillMark
53Lucia's CarMaryRoy
54ProjectCharlie
55Thursday 9/6/2022
56North GlennTony
57Central DannyGail
58South --
59Health WillMark
60ProjectWendy
61Friday 10/6/2022
62North PhilJames
63Central MaryDoug
64South HarryNick
65Health ??
66ProjectCharlie
67WEEK 3
68Monday 13/6/2022
69North KevinHomer
70Central NickJeanette
71South HarryMargaret
72Health JohnBarry
73ProjectCharlie
74Tuesday 14/6/2022
75North PhilBruce
76Central GlennNick
77South ??
78Health IanBarry
79Wollongong
80ProjectDon
81Wednesday 15/6/2022
82North PhilKaren
83Central DannySandra
84South AnnLes
85Health WillMark
86Wollongong MaryRoy
87ProjectCharlie
88Thursday 16/6/2022
89North GlennTony
90Central DannyGail
91South HarryKevin
92Health WillMark
93ProjectWendy
94Friday 17/6/2022
95North JoeJames
96Central MaryDoug
97South HarrySteve
98Health Charlie?
99ProjectDon
100WEEK 4
101Monday 20/6/2022
102North KevinHomer
103Central NickJeanette
104South HarryMargaret
105Health JohnBarry
106ProjectCharlie
107Tuesday 21/6/2022
108North PhilBruce
109Central GlennNick
110South ??
111Health IanBarry
112ProjectDon
113Wednesday 22/6/2022
114North PhilKaren
115Central DannySandra
116South AnnLes
117Health WillMark
118Wollongong MaryRoy
119ProjectCharlie
120Thursday 23/6/2022
121North GlennTony
122Central DannyGail
123South HarryKevin
124Health WillMark
125ProjectWendy
126Friday 24/6/2022
127North JoeJames
128Central MaryDoug
129South HarrySteve
130Health Charlie?
131ProjectDon
132WEEK 5
133Monday 27/6/2022
134North KevinHomer
135Central NickJeanette
136South HarryMargaret
137Health JohnBarry
138ProjectCharlie
139Tuesday 28/6/2022
140North PhilBruce
141Central GlennNick
142South ??
143Health IanBarry
144ProjectDon
145Wednesday 29/6/2022
146North PhilKaren
147Central DannySandra
148South AnnLes
149Health WillMark
150Wollongong MaryRoy
151ProjectCharlie
152Thursday 30/6/2022
153North GlennTony
154Central DannyGail
155South HarryKevin
156Health WillMark
157ProjectWendy
158Friday 1/07/2022
159North JoeJames
160Central MaryDoug
161South HarrySteve
162Health Charlie?
163Project?
1 - June 2022
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,223,230
Messages
6,170,883
Members
452,364
Latest member
springate

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top