So i have three columns - A will contain repair orders, B will contain amounts, C is irrelevant in this case. Out of around 200 samples, 30-40 rows need to be deleted. They will have the same value in column A. However, column B will have opposite values - they will net $0.00 and i need those lines deleted. But not all matching values in A will have matching values in B. Values in B that dont match must remain on the sheet.

So, I need to find out how to write a macro to look in column A, find duplicates, then look in column B and find same absolute values (but with different signs) and delete these rows. Column B values must depend on column A because i will have numerous repair orders closing for $5.00 in column B.
Attached is a sample data. First 6 rows are "in and out" net $0.00. So the macro must identify that and delete rows 1-6. The last two rows are giving me a difference of $1.00-those two rows must stay on the spreadsheet.

952527 272.20 paid not closed 09.01-09.06
952541 6.65 paid not closed 09.01-09.06
952628 5 paid not clsoed 09.01-09.06
952527 -272.20 closed not paid
952541 -6.65 closed not paid
952628 -5.00 closed not paid
952528 104.00 paid not closed 09.01-09.06
952528 -105.00 closed not paid

Thanks.