Um, not too offer too simple of a solution, but can't you just highlight the entire row by clicking on the top tab and color code every entry in that row?
Then wouldn't the tally for that vendor just be a =Sum(x,X) function at the end of the row?
Maybe I am missing something in the complexity here?
__________________
---
You do not really understand something unless you can explain it to your grandmother.
- Albert Einstein
---
|