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
Bookmarks