2 Tab Data Comparison & Update Help

[Sunshine8790]

I have 2 tabs where the first 4 columns have similar data sets.
The 1st tab is the existing data.
The 2nd tab is the new data (which may or may not be different from the existing).

Essentially: I need to be able to update "Existing Data" with the New Data.
Any new employees on New Data I will need to add to the Existing list.
All others - I need to be able to update Badge #s on the Existing list, if they differ from the New one. Same with Employee IDs.

The 2nd tab of New Data may include rows of data that are not on the Existing tab (because it's new and needs to be added to the Existing). So I can't just use conditional formatting to highlight cells that don't match, because they won't be matching until all the new data that doesn't already exist - is added.

Currently - the process is all manual, and it takes hours to complete.
If I can get some help to get some kind of conditional formatting, formulas, VBA code even - to make this process quicker and still efficient, I would be forever grateful.

Existing Data Tab:

Compare and highlight.xlsx
	A	B	C	D	E	F	G	H
1	Employee ID*	First Name*	Last Name*	Badge #	Language	Active*	Reporting Group	User Group 2
2	111111	A	Z	12345		Yes	General	General
3	222221	B	Y	23456		Yes	All Access	All Access
4	333333	C	X	13245		Yes	All Access	All Access
5	444444	A	Z	24315		Yes	All Access	All Access
6	555155	B	Y	54321		Yes	All Access	All Access
7	666666	C	X	43210		Yes	All Access	All Access
8	777777	A	Z	53421		Yes	All Access	All Access
9	101010	B	Y	68291		Yes	All Access	All Access
10
11
Existing Data

Cells with Data Validation
Cell	Allow	Criteria
E1:E11	List	=$M$1:$M$4

New data Tab:

Compare and highlight.xlsx
	A	B	C	D	E	F
1	Employee ID*	First Name*	Last Name*	Badge #	IC_Title	Last Use Date
2	123321	D	W	31524	Example	10/18/2023
3	111111	A	Z	12345	Example	10/16/2023
4	222222	B	Y	23456	Example	10/16/2023
5	333333	C	X	13245	Example	10/16/2023
6	444444	A	Z	24315	Example	10/16/2023
7	555555	B	Y	54321	Example	10/16/2023
8	666666	C	X	43210	Example	10/16/2023
9	777777	A	Z	63421	Example	10/16/2023
10	101010	B	Y	42310	Example	10/16/2023
11					Example	10/16/2023
12					Example	10/16/2023
New Data

 

[Sunshine8790]

I have 2 tabs where the first 4 columns have similar data sets.
The 1st tab is the existing data.
The 2nd tab is the new data (which may or may not be different from the existing).

Essentially: I need to be able to update "Existing Data" with the New Data.
Any new employees on New Data I will need to add to the Existing list.
All others - I need to be able to update Badge #s on the Existing list, if they differ from the New one. Same with Employee IDs.

The 2nd tab of New Data may include rows of data that are not on the Existing tab (because it's new and needs to be added to the Existing). So I can't just use conditional formatting to highlight cells that don't match, because they won't be matching until all the new data that doesn't already exist - is added.

Currently - the process is all manual, and it takes hours to complete.
If I can get some help to get some kind of conditional formatting, formulas, VBA code even - to make this process quicker and still efficient, I would be forever grateful.

Existing Data Tab:

Compare and highlight.xlsx
	A	B	C	D	E	F	G	H
1	Employee ID*	First Name*	Last Name*	Badge #	Language	Active*	Reporting Group	User Group 2
2	111111	A	Z	12345		Yes	General	General
3	222221	B	Y	23456		Yes	All Access	All Access
4	333333	C	X	13245		Yes	All Access	All Access
5	444444	A	Z	24315		Yes	All Access	All Access
6	555155	B	Y	54321		Yes	All Access	All Access
7	666666	C	X	43210		Yes	All Access	All Access
8	777777	A	Z	53421		Yes	All Access	All Access
9	101010	B	Y	68291		Yes	All Access	All Access
10
11
Existing Data

Cells with Data Validation
Cell	Allow	Criteria
E1:E11	List	=$M$1:$M$4

New data Tab:

Compare and highlight.xlsx
	A	B	C	D	E	F
1	Employee ID*	First Name*	Last Name*	Badge #	IC_Title	Last Use Date
2	123321	D	W	31524	Example	10/18/2023
3	111111	A	Z	12345	Example	10/16/2023
4	222222	B	Y	23456	Example	10/16/2023
5	333333	C	X	13245	Example	10/16/2023
6	444444	A	Z	24315	Example	10/16/2023
7	555555	B	Y	54321	Example	10/16/2023
8	666666	C	X	43210	Example	10/16/2023
9	777777	A	Z	63421	Example	10/16/2023
10	101010	B	Y	42310	Example	10/16/2023
11					Example	10/16/2023
12					Example	10/16/2023
New Data

Also, and this is an important part - any rows in "Existing" that get updated (Any Change to that row of Data, as well as any new rows of data that weren't there before) need to be highlighted.