noopura112
Board Regular
- Joined
- May 9, 2014
- Messages
- 73
Hello Friends,
Can anybody help me t owrite a VBA code for following:
I have 2 columns. In column A i have material numbers and in another column i have total net sales for those material numbers.
Some material numbers are occuring in column A twice or more than twice.
I want to consolidate all same material numbers in one row and make addition/sum of the values in column B
<tbody>
</tbody>
Output should be:
<tbody>
</tbody>
Thank you in advance
Can anybody help me t owrite a VBA code for following:
I have 2 columns. In column A i have material numbers and in another column i have total net sales for those material numbers.
Some material numbers are occuring in column A twice or more than twice.
I want to consolidate all same material numbers in one row and make addition/sum of the values in column B
Material No | Total Net Sales |
123 | 1000 |
456 | 2000 |
123 | 3000 |
456 | 4000 |
789 | 5000 |
<tbody>
</tbody>
Output should be:
Material No | Total Net Sales |
123 | 4000 |
456 | 6000 |
789 | 5000 |
<tbody>
</tbody>
Thank you in advance