I have a workbook with a tab called "Data"
On this worksheet are three columns A, B, C....named as "Contract Number", "Post No", "Car Status"
Data on Rows 2 downwards
What I want to acheive is when this worksheet is activated for duplicate rows to be deleted so that Im only left with on permitation occurance of "Contact Number", "Post No", "Car Status"
On this worksheet are three columns A, B, C....named as "Contract Number", "Post No", "Car Status"
Data on Rows 2 downwards
What I want to acheive is when this worksheet is activated for duplicate rows to be deleted so that Im only left with on permitation occurance of "Contact Number", "Post No", "Car Status"