I have an excel file with two sheets namely REPORT A and REPORT B, I want to reconcile the DATA in REPORT A with the Data in REPORT B, I need a VBA code which can do the following for me
1. First pick the TXN CODE, DEBIT and CREDIT Amount in REPORT A and compare it with the Data in REPORT B to find its MATCH or its corresponding or exact match and reconcile with it.
2. IF the TXN CODE, DEBIT and CREDIT Amount in REPORT A finds its match in REPORT B, it should indicate it as SUCCESSFUL in column F and attach the role number on REPORT B where it found it match as a reference
3. IF the TXN CODE in REPORT A finds its match in REPORT B but the AMOUNT differs and vice versa, that record range A-D should be cut and pasted in AMOUNT DIFFERS IN REPORT A or AMOUNT DIFFERS IN REPORT B
4. IF the TXN CODE, DEBIT and CREDIT Amount of particular record in REPORT A does not find its match in REPORT B , record range A-D should be cut and pasted in RECORD FOUND IN REPORT A BUT MISSING IN REPORT B
IF the TXN CODE, DEBIT and CREDIT Amount of particular record in REPORT B does not find its match in REPORT A , record range A-D should be cut and pasted in RECORD FOUND IN REPORT B BUT MISSING IN REPORT A
5. Regardless of the number of duplicates of a particular record found in REPORT A, if the same number of duplicate of that same record is found in REPORT B, it is ok with me because all duplicate will find their match and reconcile with it, it should indicate DUPLICATE SUCCESSFUL, But assume that the number of duplicate of a particular record in REPORT A is 4 and the number of duplicate of the same record in REPORT B is 3, it means there is shortage of 1 duplicate in B, then the system should cut that remaining 1 outstanding duplicate in REPORT A and paste it in OUTSTANDING DUPLICATE IN A, or vice versa
6. BALANCE per each record should be calculated in COLUMN G
I have attached a sample of my excel file
THANK YOU SO MUCH, AND MAY GOD BLESS YOU IN ADVANCE FOR DECIDING TO HELP ME
I have attached an excel file an example to the question
THANK YOU
Andy
Bookmarks