Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Automatically look for & find duplicates when data is being entered.

0

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. 

Answer
Discuss

Discussion

Post your worksheet with your code in it. Point out where your code doesn't act as you expect.  If repairing your code is more efficient for me than to write it anew that'll be better for both of us. If it's beyond repair it will still include some hints of what you want which otherwise will have to be asked and answered.
Variatus (rep: 4889) Sep 8, '20 at 9:43 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login