Using of code / macros

[ReflexTech1]

Will someone please help me with writing of the code for a macro? I would like to run it on a newly opened document.
Basically, I want the one column to use all of the rows which contain the same numbers, to give me a total of the corresponding rows' column. E.g A1,A2,A3,A9,A15 are the same ( E.g 256 ) and have a corresponding quantity in column C. To keep the number ( 256 ) the same and total up the quantity. Then basically have the one number displaying in A1 with a total quantity in C1. I want to run this macro on different exported documents, if possible.

Please advise. I have been struggling with this issue for a long time.

Thank you in advance.

 

[ReflexTech1]

Thank you very much for the help. The pivot table seems to be doing the job. Much appreciated

 

[Perpa]

Thank you very much for the help. The pivot table seems to be doing the job. Much appreciated

Reflex1,
I was pretty sure the pivot table approach would work for you. You are most welcome.
Perpa