Need help to modify this script to summarize totals

Can someone modify this script to bring back the total by vendor not just the highest value? I need it to look at the value in cell AP25 the return by vendor in decending order in AN27-APxx for any vendor that has a sum in column B greater than the value in AP25.

thanks in advance, s4

Please Login or Register  to view this content.

It misses picking up one vendor, Nichols has a total of 10.51, I can't determine why yet.

What I wrote was running through the persons names, not the customers, so the nichols account was mixed in with another one. Use this instead:

Please Login or Register  to view this content.