lhernandez
Active Member
- Joined
- May 22, 2006
- Messages
- 282
I have just used a macro to run through a worksheet and derive a list of the descriptions and quantities I need.
Is there an easy way to write a macro to run through this new list to find any duplications and print the description once and add up the quantites from the all the duplications?
Ex:
Low Voltage Cable - 10
High Voltage Cable - 5
Low Voltage Cable - 5
High Voltage Cable - 10
Low Voltage Cable - 20
Euqla to:
Low Voltage Cable - 35
High Voltage Cable - 15
Is there an easy way to write a macro to run through this new list to find any duplications and print the description once and add up the quantites from the all the duplications?
Ex:
Low Voltage Cable - 10
High Voltage Cable - 5
Low Voltage Cable - 5
High Voltage Cable - 10
Low Voltage Cable - 20
Euqla to:
Low Voltage Cable - 35
High Voltage Cable - 15