Hi All
I'm fine removing duplicate rows based on one criteria
Range("A:H").RemoveDuplicates Columns:=3, Header:=xlYes
But ideally I only want to remove rows where the data is duplicated for that row in column A & C elsewhere.
I hope I have explained this correctly. Been banging my head over this for hours
Any help would be appreciated
Cheers
Paul
I'm fine removing duplicate rows based on one criteria
Range("A:H").RemoveDuplicates Columns:=3, Header:=xlYes
But ideally I only want to remove rows where the data is duplicated for that row in column A & C elsewhere.
I hope I have explained this correctly. Been banging my head over this for hours
Any help would be appreciated
Cheers
Paul