VBA to sum all duplicate ID and paste to new sheet

[tantcu]

Hi,

I'm looking for a VBA or a formula that could sum all the duplicate ID and go to the new sheet to paste unique ID and the sum of all the data. If you look at my spreadsheet, I want the result looks like in Sheet2.

Thanks,

Sum Duplicate Data.xlsx

[tigeravatar]

tantcu,

Using your provided workbook, in 'Sheet2' cell C5 copied over and down:

Please Login or Register  to view this content.

[tantcu]

Hi Thank you for the reply. Sheet2 just the sample result I want to have. Imagine you don't have the unique ID in sheet2 to do SUMIFS just yet. How do you handle that issue when it could be thousands of data in sheet1

[tigeravatar]

Use advanced filter to get the unique list
http://www.contextures.com/xladvfilter01.html