Deleting duplicate offsetting rows

I think I have a problem that hasn't been discussed in any forums I've searched.

I need to delete rows where all criteria are the same except the fees column are offsetting values; sum of 0. Example:

Acct No. Name Date Provider Fees
001 Dave 1/1/08 Fred 500
001 Dave 1/1/08 Fred -500
001 Dave 1/1/08 Fred 500
002 Jeff 1/1/08 Fred 500
003 Fran 1/7/08 Eric -250

Either rows 1 and 2, or rows 2 and 3, need to be deleted. The negative value in this example is due to an erroneous charge being negated. Once the offsetting rows are deleted all negative values in the fees columns will need to be deleted, row 5. There are about 10,000 rows of data.
After reading other posts it appears that the best approach is to start is at the last row and compare it to all of the data above it but I am at a loss as to how do do this. Any and all help is greatly appreciated.

Hi royUK,
Thank you for the response, however the macro only deletes the headers in the spreadsheet. Is there any additional information I can provide to clarify?

Thanks again for your help!

Hi Simon,
If A,B,C and D are the same and the values in column E sum to 0, then both rows need to be deleted. Once that occurs, the remaining negative amounts would need to be deleted and finally, for cleanliness only, all rows with 0 on column E need to be deleted. I suppose if the rows with 0 in column E are deleted first there will be fewer rows to check.

Thank you for your help.