How do we tell what is duplicated? From your data, you have highlighted 4 rows which are not similar. In each case the Style No. is different.

I'm having some difficulty in following your request as the title suggested you wanted to "turn this code into a macro" but it eventually seems that you want to find and delete duplicates and add the value of the duplicated row to the original row. I can only assume you require the Ctn No's to be added.

Can you please take the time to explain in better detail what you are chasing here?