Sumif and Delete duplicate Rows (VBA CODE)

[Metrazal]

Looking for VBA code to sum column E in a sheet named C5972 for matches in column C and delete any duplicate rows.

See attached sample.


I appreciate any help.

Thanks,

Met

[JieJenn]

Have you considered pivot table?

[Metrazal]

I my case a pivot table is not viable.

Thanks,

Met

[AB33]

Try the attached.

[Metrazal]

AB33:

Thanks for the response. I was able to modify your code to better fit my needs and it worked great.

Thanks,

Met