Reconciliation

Hi Folks,

I need some expert advise in how to develope a macro function to reconcile some lines that correspond to some criteria.

The example attached will give you some idea of what I am talking about. I need to find a simple and quick way to remove from this table the lines where "Supplier" AND "Invoice" values are the same AND the sum of "Amount" is equal to zero.

Filtering it is laso a solution. But it's not very practical when you have a list of 1,000 different suppliers.

Much appreciate any advise.