Sum Column based on information in another column in excel

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