statement reconciliation

Hello,

Pls find sample of my data attached...the main statement is dumped in the 'statement' sheet. The statement contains credit and corresponding debit entries later...

I would like a macro which will reconcile the statement based on the amount, narrative and date. The amount, narrative of credit entry should match with the debit amount with same narrative. In addition to that, the debit entry date should be either equal or later than the credit date. If the entries are reconciled, the reconciled items should be copied and reflected in 'reconciled' sheet with reconciled entries adjacent to each other and all unreconciled items should be in 'unreconciled' sheet...

Any help with this will be appreciated...

The data changes so I need a macro for this..