amend code merge duplicated data

actually i found the mistake about sum values but the col c, d are missed it gives me this error in cells #N/A
any body help ,please ?

yes , nankw this is what i would but when i run again gives me message replace content cells and gives me error can i get rid of this upset message

i want to clear previous data & put new data in place

thanks nankw your code works so well

Glad to help & thanks for the reps 👍

hi, Dante
actually this code is yours i got one of your sharing from mr exel forum i like this code is short and quick i was searching like this code to do my job and i try amending the code but it missed me this simple part to adjusting so i appreciate your updating your code thanks so much
god bless you