Looking for a code

[purplewarda]

I am looking for a code to transfare some numbers from sheet1 to sheet2,
I do not want all the codes from column A.
example column A has some codes I do not want to move, I want to move for example code 82247 from sheet1 Column A to sheet2 and I want it to show only one time in sheet2 and I want to move the last row all from sheet1 to sheet2 that matches this code. but I want it to add just column M so I will have the sum of column M .example in the bottom

[royUK]

Most people posting in this Forum are "looking for a code" Read the Forum Rules & use appropriate Thread titles. Thanks.

[purplewarda]

I am looking for a code to transfare some numbers from sheet1 to sheet2,
I do not want all the codes from column A.
example column A has some codes I do not want to move, I want to move for example code 82247 from sheet1 Column A to sheet2 and I want it to show only one time in sheet2 and I want to move the last row all from sheet1 to sheet2 that matches this code. but I want it to add just column M so I will have the sum of column M .example in the bottom