VBA to look for matches and then compare?

[goob90]

Is it possible to compare two columns for a match and if there is a match compare two other columns?

For example, I want to compare two workbooks with similar data.

• The FIRST thing I want to check is that there is a match for employee numbers.
• If there isn't a match, I would want it to be copied and pasted to a new workbook.
• The SECOND thing I want to check is that if the employee number matches, does the deduction amount?
• If there isn't a match, I would want it copied and pasted to the same workbook as the first non-matching.

Workbook 1

Recon+ Blueprint.xlsx
	A	B	C	D
1	Name	Employee ID#	Deduction/Benefit	Deduction Amount
2	Dwight Schrute	2669	DPHO, DPHO, DPB, DPB	$ 81.80
3	Jo Bob	2308	DPHO, DPHO, DPB, DPB	$ 56.40
4	Ahsoka Tano	5134	DPLO, DPHO, DPHO, DPFIX, DPB, DPB	$ 66.92
Sheet3

Workbook 2

Recon+ Blueprint.xlsx
	G	H	I	J
1	Employee Name	Emp ID	Product	Total Amount Due
2	Andy Bernard	5687	Dental	56.4
3	Jo Bob	2308	Dental	56.4
4	Dwight Schrute	2669	Dental	90
Sheet3

The key here is that I could have non-matches for the first criteria and second criteria on their own sheet so that they can be reconciled. Bonus points if the user can use a macro-assigned button to choose the two workbooks being compared.