hi everyone,
I have a columns in which there is a list of codes and a column in which here are amounts.
each time i have to upload new codes to the excel and perform the sum on its amount. Below is an illustration:
Codes Amount
147 200.00
147 100.00
147 50.00==>i have to sum amount for “147”
230 2000.00
230 150.00
230 25.00==>i have to sum amount for”230″
Is there an Excel or VBA solution for this?
Please help
Thanking you in anticipation
Dwij
