mrzesty973
01-12-2017, 10:06 PM
I need vba code that can take a list of invoices that are found on sheet 1 (called AR Invoices) and sheet 2 (called AP Invoices). The code would perform the following operations and then place the results on a third sheet called Recon Sheet. The lists would be sorted in ascending order, and then compared to each other. When there is a match, the code will line up the data onto one row. If there is not a match, the code will insert the word "missing." There is also the potential for duplicates. The duplicates would get separated and moved to separate columns. The final result would look like the screen shot below.
List A
List B
Duplicates
AR Invoices
Total
AP Invoices
Total
Invoice #
Total
14221
$ 1.00
14221
$ 2.00
3044776
$ 6.00
3044771
$ 2.00
Missing
7400362
$ 5.00
3044773
$ 3.00
3044773
$ 3.00
7384580
$ 4.00
Missing
7400362
$ 5.00
7400362
$ 4.00
Missing
3044775
$ 5.00
Missing
3044776
$ 6.00
7400362
$ 5.00
3044776
$ 6.00
I have included a workbook with the data. The lists will vary in length from project to project.
Thank you in advance.
List A
List B
Duplicates
AR Invoices
Total
AP Invoices
Total
Invoice #
Total
14221
$ 1.00
14221
$ 2.00
3044776
$ 6.00
3044771
$ 2.00
Missing
7400362
$ 5.00
3044773
$ 3.00
3044773
$ 3.00
7384580
$ 4.00
Missing
7400362
$ 5.00
7400362
$ 4.00
Missing
3044775
$ 5.00
Missing
3044776
$ 6.00
7400362
$ 5.00
3044776
$ 6.00
I have included a workbook with the data. The lists will vary in length from project to project.
Thank you in advance.