Hi,
I need help to write a macro or formulas to do reconcile two sheets.
Sheet "A" has list of all the issued cheques for the month and outstanding
cheque list from prior months. In Sheet A : column A - Cheque number, Column
B - Amount. Sheet "B" has list of cashed cheques for month given by bank. In
sheet "B" Column A - Cheque Number and Column B - Amount.
I am trying to come up with macro or formula so that cheque numbers can be
matched and column C shows the matched cheque number from Sheet A and column
D shows the amount, Column E shows the difference in amount i.e. column
b-column d. All the matched cheques should get deleted from sheet "A" so that
sheet A is outstanding list for the cheques.

Please help. Thanks in advance