Delete all rows for given FirstLast name where total payment sum is "negative"

Hi, I have a program that works. But i have to go through the file 3 times and for large files this may not be good. Also, i was wondering ifthere is a "better" way to approach this than what i did. So what i did (i include the code) is as follows:
Loop1: build dictionary where the key is the firstlast-name and contents of the dictionary sum the payments value for given firstlastname.
Loop2: adds elements to this dictionary where the sum of the payments value is negative
Loop3: remove those rows where the firstlastname is negagive.

not sure if there is a better way or not .....this seems to work though.

But i have to go through the file 3 times and for large files this may not be good.

About how many rows is your data?

daboho, i get a type mismatch error at this step

Please Login or Register  to view this content.

akuini, i am not 100% sure of the number of rows....it can vary between 6000 and 30000

Question:

What does this do:

Please Login or Register  to view this content.

What does this do:

Please Login or Register  to view this content.

How does rng change value?

I've corrected the code in post4 - it should have been looking at column C, not A

This join the ranges rng and f

Please Login or Register  to view this content.

This evaluates a sumif formula which sums column D where C = C of the row the loop is currently at

Please Login or Register  to view this content.

welchs101,

Use of Array, Dictionary & AutoFilter.

Please Login or Register  to view this content.