I need to compare more than two worksheets and reconcile differences for Charge amounts.
Each sheet corresponds to a unique Company, e.g. Company1, Company2, Company3, etc.
The data columns are the same in all sheets - Name, Product, ID Number and Charge.
It needs to produce a “Reconciliation” sheet with the comparison results from each of the multiple sheets.
Also, it needs to create a “Differences” sheet with only those having Charge amount differences.
I found some excellent VBA code written by Jindon here: http://www.ozgrid.com/forum/showthread.php?t=174992 and have modified it in my attempt to produce the above.
I have attached my example which uses 4 Company worksheets. You will see it generates the Reconciliation and the Differences sheets, but results only show for Company1 and Company4. It does not list results of Company2 and Company3. Finally, there’s an issue with the results. “Allen GHI 111111” with a Charge amount of $250 is in the first three Company sheets, but not in Company4. However, in the results it shows $250 under Company4 when it should be blank.
If you can help me with this it will greatly be appreciated!