Hi,
I am looking for a vba code which searches a table for items with same reference, adds of the corresponding amounts . if it adds to zero, delete the items from the table. see below example
Ref amount
a102 50
b156 25
a102 -50
a568 12
a578 10
So, i will like to search and delete lines 1 and 3 as they add up to zero.
Thank you