Grouping similar items in excel

[makmool]

have Some Values in excel
and I wish to collect them as this pic. how can i do this in vba untitled.JPG

[sky1in5]

=sumif

if aaa is at a1 and value at b
beside aaa cell put =sumif(a1,a:a,b:b)

[makmool]

I Need this to be done using vba (the below table to be created with the values from the upper table)

[sky1in5]

can specific the column and row for the name and value? thanks..

[makmool]

Column A for name
Column B for Value

[sky1in5]

Please Login or Register  to view this content.