How to write the VBA code with the highest sales sorted to the smallest

The data source is in column A and B, and the result is placed in column G and H
The highest sales are sorted to the lowest sales and the product names are not repeated
The product name is the same, and the sales amount is added together

Can someone please help me . It would be much appreciated . Thanks in advance

Is there a reason you want to use VBA? You could easily do this with a pivot table.

Thanks Norie GURU for quick reply

Knowing that pivot table can easily solve the above problems, I want to learn how to write this VBA code to do it

Is it difficult or simple to write this code?

Excellent solution. Thank you both, Thank you jindon GURU very much for the solution.

I don't know what happened to the forum today, I can't ADD Reputation, Click but no response

If it really doesn't work today , I will add another day