Hello all,
I would like to achieve a reconciliation of employer deduction report aka ('Sheet A') with company deduction report ('Sheet B') line by line. Here are the things i would like to achieve with this:
The reconciliation should reveal any change in any of the rows under the various headers so i need a macro or formular that can pick each of the cells in each worksheet and compare with the other cell in the other worksheet. Any row in 'Sheet A' that matches a row exactly in 'Sheet B' should return a remark "reconciled" in the "Remark" field. Any row in 'Sheet A' that does not have an exact match with any row in 'Sheet B' should return a remark "Not Reconciled" in the "Remark" field.
I am hoping the solution can also create a new worksheet and put the two sheets side by side and match the reconciled rows and leave the unreconciled rows as an exception report sorted at the bottom of the sheet.
Please find attached a 'test' workbook. I have altered some data in 'Sheet B' as a control for the result of the solution.
I will be grateful for a solution as this thing takes me weeks to reconcile and really affects my job.
Bookmarks