VBA to Compare Two Workbooks Using a Common Identifier, Compare Matches, Export Mismatches

[goob90]

I am working on a project to reconcile payroll data. I apologize if I ramble, I've tried to lay this out the best that I could, but as usual, my mind is scattered! Any input or suggestions is greatly appreciated!

I have an outline of what I am wanting to do:

User Selection:

Recon+ Blueprint.xlsx
	B	C	D	E	F	G	H	I
2	Reconcile App
3
4
5
6		Click to Select Payroll Workbook			Reconcile!
7
8
9
10		Click to Select Invoice Workbook
11
12
13
14
15
VBA Idea HS

Payroll Report:

Recon+ Blueprint.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L
1	Payroll Report
2	Name	Employee ID#	Birthdate	Hire Date	Termination Date	Status	Department	Year	Month	Coverage Period	Deduction/Benefit	Deduction Amount
3	Dwight Schrute	2669	5/2/1982	5/12/2014		Active	Sanitation	2022	1	01/01/2022-02/01/2022	DPHO, DPHO, DPB, DPB	$ 81.80
4	Jo Bob	2308	2/18/1968	5/2/2003	1/22/2022	Active	CEOC	2022	1	01/01/2022-02/01/2022	DPHO, DPHO, DPB, DPB	$ 56.40
5	Ahsoka Tano	5134	11/4/1996	5/3/2021		Active	Police	2022	1	01/01/2022-02/01/2022	DPLO, DPHO, DPHO, DPFIX, DPB, DPB	$ 66.92
VBA Idea

Carrier Invoice:

Recon+ Blueprint.xlsx
	N	O	P	Q	R	S
1	Carrier Invoice
2	Coverage Period	Employee Name	Emp ID	Product	Contract Type	Total Amount Due
3	01/01/2022-02/01/2022	Andy Bernard	5687	Dental	Emp Only	56.4
4	01/01/2022-02/01/2022	Jo Bob	2308	Dental	Emp Only	56.4
5	01/01/2022-02/01/2022	Dwight Schrute	2669	Dental	Emp Only + Spouse	90
VBA Idea

Discrepancy Report Idea:

Recon+ Blueprint.xlsx
	A	B	C	D	E	F	G	H	I
1	Name	Employee ID#	Department	Coverage Period	Deduction/Benefit	Product Type	Contract Type	Deduction Amount	Invoiced Amount
2	Dwight Schute	2669	Sanitation	01/01/2022-02/01/2022	DPHO, DPHO, DPB, DPB	Dental	Emp+Spouse	$ 81.80	$ 90.00
3	Ahsoka Tano	5134	Police	01/01/2022-02/01/2022	DPLO, DPHO, DPHO, DPFIX, DPB, DPB			$ 66.92	Not on Invoice
4	Andy Bernard	5687				Dental	Emp Only	$ 56.40	Not on Payroll Report
Sheet6