VB Code to sum repeated values?

Hi Folks,

I am new to VB programming and need your help in solving following problem,

Excel Input,

Name Qty
A 1
A 2
B 1
C 5

Excel OutPut,

Name Qty
A 3
B 1
C 5

In other words I would like to sum the corresponding Qty value of all repeated Names (In this case A).

Any help in this regard will be appreciated.

Thanks,
Manish

Thanks for your reply