Auto Generate List of Names?

Try using a Pivot Table.

Try this formula in G2 and copy down

=SUMIF($A$2:$A$25,F2,$C$2:$C$25)

change your range accordingly

sorry for not reading your post properly -- if you highlight your venders in column A and go to Data / Filter / Advanced filter -- make sure your range is proper click in Copy to another location ---- in copy to put in F2 and put check in Unique records only