Using VBA, Pair Off and Delete matching totals which sum to 0

[swade730]

Hi All,

I have attached a workbook and using VBA I would like a clue on how to resolve the issue I have.

There is a Column for Debits and some of the values match the Amount which are in the Credit Column. Column E & F respectively.

How could I write a Macro to recognize the ABS (Absolute) values are the same or the value is the same and delete the matching value rows.

This would need to loop through the spreadsheet but If I can get a slither of code to get started I can try to finish my own approach to reflect my thought process.