I need some help with this! I have a parts list that can be very long. If the same part shows up in more than one row I want to add the totals and remove the duplicate part number's row. Below is an example of what I want to accomplish...

I have this...

P/N.......... Description............... U/M..........Qty
1234.........rivet..........................ea.............1
1234.........rivet..........................ea.............4
345...........washer.....................ea.............12
65.............nut...........................ea.............4
3846.........prepreg.....................sf..............24
3846.........prepreg.....................sf..............12
64.............primer......................ga.............14

I need it to look like...

P/N..........Description................ U/M..........Qty
1234.........rivet..........................ea.............5
345...........washer.....................ea.............12
65.............nut...........................ea.............4
3846.........prepreg.....................sf.............36
64.............primer......................ga.............14

As you can see the part numbers (p/n) 1234 and 3846 now show totals and are not duplicated. This also needs to happen dynamically because this parts list changes all the time. I would like not to have to do a macro for this but if it's the only way then I will. Please help! Thanks!