If the values in column a are duplicate, sum the corresponding values in column B

Hello VBA Gods, an amateur is need of help.

I have values in column A representing IDs and values in column B representing amounts purchased by those IDs. I now need to write a sub that finds the total amount spent by each customer on the list and reports those whose total is more than $800 on a new worksheet.

I have written a code that works to sort the data according to ID number to make this problem easier. I know I will have to use a Loop, but am confused as to how I should proceed to write the sub.

Thanks in advance!

I know how to do this with pivot tables, but the question specifically asks to use VBA

Assuming Herder in 1st row, data starts from A2

Please Login or Register  to view this content.

Thanks Jindon! But do you know of any other ways to get this to work without using the scripting dictionary? This is not something I have learned yet. Thanks again!

What did you learn then?

So far I have learned the basics like arrays, loops, using Excels functions in vba. Its the basics. I thought this problem might be solvable using the basics and a few types of loops like for each, do until, do while.
Thanks again for the quick responses

Basic excel functionality only.

Please Login or Register  to view this content.

Thank you! This makes a lot more sense to me. I was wonderinf if there was anyway to use the do until loop in this problem, as that is what i was thinking of using first. Something that would sum the purchases $ cells until the A column cells did not equal each other, and then i would loop to the next ID in column A somehow? So i would have to use For Each in the code as well?
Sorry for all the questions, just trying to see if my thought process was somewhat correct.

If you think so, just write a code for yourself first and ask where you stuck.