intercompany reconciliation

Hi All

Looking for a solution for reconcile intercompany transactions within 2 spreadsheets

I need some expert advise in how to develope a macro function to reconcile amount lines.

The example attached will give you some idea of what I am talking about

Thank you!