One of the guys in my office (different group) uses Pivot Tables for exactly this sort of thing. In 2007 you create the pivot table and then just drag the data from a list on the side to it and it adds the quantites based on part number automatically (and pretty damn quickly).

Sorry I can't be more help than that, but yesterday was the first time I even saw a Pivot Table.