EquipmentPartsSales
New Member
- Joined
- Sep 17, 2018
- Messages
- 6
I have a large inventory file I am working with. The data looks like this:
<tbody>
</tbody>
Basically what I would like to do is if the number in column NSN has a duplicate then add up the values in the QTY column. For this example it would like like this:
<tbody>
</tbody>
I do not know if there is a simple formula or a VBA code that will achieve this. My inventory list has roughly 200,000 lines. Any help would be greatly appreciated.
NSN | Part number | Condition | QTY | DESC |
1005001950897 | 11662739 | NS | 7 | MOTOR |
1005001950897 | 11662739 | NS | 2 | MOTOR |
1005002676740 | 368506201 | NS | 4 | HOUSING |
1005005013201 | 5013201 | NS | 1 | SPRING |
<tbody>
</tbody>
Basically what I would like to do is if the number in column NSN has a duplicate then add up the values in the QTY column. For this example it would like like this:
NSN | Part number | Condition | QTY | DESC | Total Qty |
1005001950897 | 11662739 | NS | 7 | MOTOR | 9 |
1005001950897 | 11662739 | NS | 2 | MOTOR | |
1005002676740 | 368506201 | NS | 4 | HOUSING | |
1005005013201 | 5013201 | NS | 1 | SPRING | |
<tbody>
</tbody>
I do not know if there is a simple formula or a VBA code that will achieve this. My inventory list has roughly 200,000 lines. Any help would be greatly appreciated.