Hi,

I am need some help with this, i am absolutly new to vba.
I have a worksheet with two colums as given below
Id value
1 10
1 10
1 10
2 10
2 10
3 10
3 10
3 10


I want to SUM the values column based on the Id, that i mean is i
want
to write a VBA macro that helps me generate an output of the form:


Id value
1 10
1 10
1 10
30
2 10
2 10
20


3 10
3 10
3 10
30


Any help is really really appretiated


Thanks

No need for a macro - Data | Subtotals will do this for you:

for each change in ID, sum value

Hope this helps.

Pete

On Oct 29, 4:48 pm, "
wrote:
Hi,

I am need some help with this, i am absolutly new to vba.
I have a worksheet with two colums as given below
Id value
1 10
1 10
1 10
2 10
2 10
3 10
3 10
3 10

I want to SUM the values column based on the Id, that i mean is i
want
to write a VBA macro that helps me generate an output of the form:

Id value
1 10
1 10
1 10
30
2 10
2 10
20

3 10
3 10
3 10
30

Any help is really really appretiated

Thanks