Add up quantitites in Column E based on duplicates in Column A, then delete duplicates

I need to have the quantities in column E added up the duplicate part numbers in Column A. (Top Image is what I have, bottom is what I need).
I need this to be done in VBA because it is a Sub called by another Sub.

I have script that can easily delete all duplicates, but my problem is that I need the TOTAL quantity for the repeated part number and I am not good enough with VBA to accomplish that.

Can anyone help? PLEASE NOTE that the image has an error. Part# 05-80100-375 should be in my "what I want" image only ONCE and the total should be 83 in column E. (Didn't notice that until I had already saved the image)

Thanks!ju3Yw6M.png

Untested

Please Login or Register  to view this content.

Awesome! Thank you very much!!!

Hi,

From your images, here is code that should consolidate quantities:

Please Login or Register  to view this content.

Hope that helps,

Dan

Thank you! I will give it a shot! I appreciate all the help!