macro that deletes matching under same client and odd entries

Hi guys

I have no idea how to start this can someone please help as it would simplify my work a lot.

I have 3 columns I want to compare

Column A = Clients
Column G = Amounts
Column N = Case ID


So let’s say

Client | Amount | Case ID
Mike | 50|123
John | -50 |123
Mike | 50 |123
Mike | -50 |123
John | 20 |456
John | -20 |456
Mike| -20 |456


I want the macro to:


Find debits and credits that match with the same client and case ID e.g. Mike has go a debit and a credit for 50.00 and john has got a credit and debit for 20.00 under the same case ID (Macro is to delete these transactions (Row))
Remove any transactions that don’t have an contra, e.g. once matching has been deleted Mike will be left with a credit for 20.00 and the case ID and amount doesn’t match any other transactions (I need this to be deleted)
Then I should be left with debits and credits that match for different clients for example John has a credit for 50 and mike has a debit for 50 under the same case ID, so I should be left with:


Client | Amount | Case ID
Mike | 50|123
John | -50 |123

I’d really appreciate it if someone could help me write a macro to do this, please use Column A, G and N as stated above.

Thank you

Hi

I don't want it to add the totals and move them to a new sheet, I need it to just delete the row.

Thanks