Stuck: Compare worksheet value and output to new file with unchanged AND changed values

[Luigi]

I've just started this job, and I know this can be done easier than it is right now. Currently, it takes days to manually locate changed data in a newly submitted file (WB2) and update the master spreadsheet (WB1).

I've used the Compare worksheet function in Excel 2016 which has provided me some information (at least I can use that to see what lines have changed); however, having to review and update to a new spreadsheet with 1000+ lines with values is painful (I have many).

This project has WB1 is master file, and WB2 is "slave" with updated info. The workbooks are identical EXCEPT for the updates in WB2, which may include new rows.

Is there a way to:
1. Compare sheet 1 of of WB1 against sheet 1 of WB2 then
2. Take that output and create the new WB3?

Can I take what is NOT changed in WB1 -- as well as what HAS changed (in WB2) -- and create or merge results to a WB3 (with changes highlighted)?

I cannot see this functionality anywhere, and I'm an early learner with VBA. I'd appreciate ANY advice/direction.

 

[AhoyNC]

This link will show how to merge the lists without duplicates.
https://www.get-digital-help.com/20...m-two-columns-using-excel-2007-array-formula/

Another option would be to copy list 2 below list 1 on your WB3 then under the data ribbon select remove duplicates.

You could use the example below to get a list of items in list 2 that are not in list 1.

Excel Workbook
	A	B	C	D	E	F	G
1	List1		List2		Not in List 1		# Items not in List 1
2	Name1		Name1		Name55		4
3	Name2		Name2		Name9
4	Name3		Name3		Name10
5	Name14		Name14		Name11
6	Name5		Name55
7	Name6		Name6
8	Name17		Name17
9	Name8		Name8
10	Name99		Name9
11			Name10
12			Name11
13			Name5
Sheet