VBA code reconciliation two excel worksheets

Hi

Please can someone help or provide me with a code where i can reconcile two worksheets. One will confirm a receivable position of company A against company B and the other the Payable position of Company A against company B.

Both sheets will have the same headers in the same order.

e.g. Reporting company, invoice number, invoice amount, Receivable.

I would then like for a macro to reconcile and confirm what invoices are missing and provide this as a list of highlight them?

Any help will be much appreciated.

Ana

Yes please but i want a more official confirmation can the mismatches on both ledgers be reported on a seperate sheet? Confirming which reconciling items are on the reporting and vice versa.