Add until...

[sted999]

Hiya there.

I am very new to VBA programming (and programming as a whole!) and have become a little stuck. I have several entries per person and what I am wanting to do is add the number in one column (Column B) until a new person (Column A) and then reset the count for the next person.

Any help is greatly appreciated.
Thanks is advance.

[snb]

You'd better add (until).... your example workbook .

[royUK]

Sort & SubTotal would be the best way, no VBA needed. Or maybe even a PivotTable