Auto-populate from other sheets in a master, than auto total duplicates

http://www.excelforum.com/excel-prog...-workbook.html

I found the above thread and this worked with what I needed to do, but I was wondering. I am using part numbers and QTY on 7 tabs ( different sections of macahines). The same part number could be used in the different sections (o-ring as an example) is there a way that when it auto populates on the master sheet that it can tally and provide a grand total if there are duplicates entered?

I have highlighted the duplicates, on the master but not sure how to go about consolidating the totals

Any help or advise would be great

Thank you

Try the attached.

Originally Posted by AB33

Try the attached.

Hi AB33

Thank you for the reply, unless I am missing something. On the Master Parts list there are still duplicate entries for the parts.
I even tried adding new part numbers and it is not totaling/combining them.

Appreciate the help

Thank you

Regards

Mel

Mel,
No, so long as the part nos are EXACT match. Show me which duplicates does not add.
The code adds the QTY with same part nos.

Hello

Please see the attached, I have highlighted the dup's as well added 2 test part numbers to show it's not adding them together

Thanks again

Mel

I have added trim to remove some spaces, but you need to remove the non numeric numbers in some columns B. The code will not add if the Qty is non-numeric cell. To overcome this error, I have reluctantly added an error trapping line.

I really can't thank you enough for your help! I will go in and remove the non numeric info... again thank you! Have a wonderful weekend