PaigeWarner
New Member
- Joined
- May 27, 2020
- Messages
- 48
- Office Version
- 365
- Platform
- MacOS
Need Macro that looks to the duplicates in one column only and deletes the whole row of duplicates, but keeping one row.
The Macro Recorder gives you the base code, and then you may need to generalize it a little.The duplicate variations and data will be different every time so I am not able to turn on the macro recorder for this.
Sub DupDeleteMacro()
Dim lr As Long
' Find last row in column C with data
lr = Cells(Rows.Count, "C").End(xlUp).Row
' Delete duplicate rows on column C
ActiveSheet.Range("$A$1:$L$" & lr).RemoveDuplicates Columns:=3, Header:=xlYes
End Sub