Combining duplicate cell data vba

[5SRopp]

I have two columns (part numbers, quantities) of data that are generated when a serial number is entered into a third column. There are multiple serial numbers for each part number. I want to use a userform button that will add the quantities associated with the part numbers and show grand totals. For example, if part number xyz is listed 5 times in the column B and its quantities are 1,2,3,4 and 5 in column C respectively I want to show that the grand total of part xyz is 15. Would creating a pivot table in a macro be a legitimate way of doing this?

 

[VoG]

Data > Subtotals should do that.