Excel_Learner29
New Member
- Joined
- Apr 1, 2019
- Messages
- 5
Hi Team,
I am looking some help on creating a macro which could help me sum values in column for B for similar text in col A and insert the sum field in col b for after every group its sums up and also insert a blank row after its sum the data
<tbody>
</tbody>
Macro to return :-
<tbody>
</tbody>Appreciate your help
I am looking some help on creating a macro which could help me sum values in column for B for similar text in col A and insert the sum field in col b for after every group its sums up and also insert a blank row after its sum the data
Names | Value |
Apple | 25 |
Apple | 10 |
Orange | 10 |
Orange | 45 |
Milk | 20 |
Milk | 40 |
<tbody>
</tbody>
Macro to return :-
Names | Value |
Apple | 25 |
Apple | 10 |
35 | |
Orange | 10 |
Orange | 45 |
55 | |
Milk | 20 |
Milk | 40 |
60 |
<tbody>
</tbody>