Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Data from One Group of Cells to Another Group | Charts and Charting in Excel | |||
Group a range - closing the group does not hide the controls.... | Excel Programming | |||
Sort by Group Header or by Group SubHeader | Excel Programming | |||
Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
How do I group worksheets (Lotus 123 function is "Sheet>Group Shee | Excel Worksheet Functions |