Group by SUM
 

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

Group by SUM
 

While you can do this with a macro, you may find it much easier to use
Data/Subtotals...

In article .com,
" 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

Group by SUM
 

On Oct 29, 11:24 pm, JE McGimpsey wrote:
While you can do this with a macro, you may find it much easier to use
Data/Subtotals...


Could you be kind enough to give me an example
or point me to some link where i can get more info

i am new to vba

In article .com,



" 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- Hide quoted text -

- Show quoted text -

Group by SUM
 

My suggestion (Data/Subtotals) doesn't require VBA. See the "About
subtotals and grand totals" topic in XL Help.

In article . com,
" wrote:

Could you be kind enough to give me an example
or point me to some link where i can get more info

i am new to vba