vba macro to sum by group

viva0521

New Member
Joined
Jul 6, 2015
Messages
7
Hey there,

suppose I have a table like this:

VFromToindexdecision
v1D1A11ship
v2D1A11ship
v3D1A11ship
v4D2A21ship
v5D2A21ship
v6D2A3no ship
v7D2A3no ship
v8D3A3no ship
v9D3A31ship
v10D3A31ship

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

how can i create a macro to sum up by group (from, to , index) like following:

VFromToindexdecision# of ship
v1D1A11ship
v2D1A11ship
v3D1A11ship3
v4D2A21ship
v5D2A21ship2
v6D2A3no ship
v7D2A3no ship
v8D3A3no ship
v9D3A31ship
v10D3A31ship2

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

please advise!
Thanks!
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Watch MrExcel Video

Forum statistics

Threads
1,108,993
Messages
5,526,118
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top