Hi Everyone:
I have an excel document that serial numbers of a job can be entered starting from row 37, columns a - c to bottom of worksheet.
Each serial number should be unique. Recently I have found muliple instances of duplicates being entered, so I created a macro that highlights duplicates within the worksheet after data has been entered. Unfortunately, the users do not always run it and I continue to find mistakes.
I have been trying to create a worksheet_change event but have been unsuccessful.
I would like to find a way to automatically check for duplicates entries in worksheet as data is being entered starting at row 37, Columns A – C to bottom of worksheet.
If a duplicate is found, a message prompt to user and highlight duplicate text.
Once the duplicate is removed, continue checking for duplicates as data is entered.
Thank you for any help you can give.