I downloaded the file. I got a run time error 1004: Application not defined or object-defined error for the following code.


.Range("SUPPLEMENT").FormulaR1C1 = _
            "=SUMIF(R[1]C[-11]:R" & BottomRow & "C1,RC[-11],R[1]C[-1]:R" & BottomRow & "C11)"
I was wondering if C11 should be C[-11]? Also Ctrl + m does not activate the macro.

We are so close and thanks for all your help. I was wondering if there is a way to delete the duplicate rows at the end of the macro.

Thanks so very much.