Macro replacing Pivot table ?

[BBHRVS]

In column 1, I have names : Mr a, Mr b, Mr c, Mr D,...
Each of them can appear several times
In column 2, I have values
I want to sum up per name the values by macro
I should get something like :
Mr A 300
Mr b 252
Mr c 855
...
These totals will be incorporated in an other macro.

This is the same thing as a pivot table, but I don't want to go through a pivot table, as it needs to create a worksheet and so on.
Is there a way to do it by macro ?

 

[Andrew Poulsom]

You can put a Pivot Table on the same sheet. It will be the easiest way to get what you want.