Prevent Duplicate Entries in Excel Automatically with VBA Macro

This Excel VBA Tutorial explains how to prevent duplicate entries and allow only Unique Entries automatically. We can use simple vba code with looping statement and if condition to check if entered value is already existing in the same column. Also, how to delete entire record automatically if entered value in specific
column is duplicate.

[vibhuvarshney]

could you help if I need to save data in sheet 2 from sheet 1 and avoid duplicate entries in sheet 2, where I need to compile my data

[broudjzed]

Hello boss how to update database once by transfering all listbox items once tanks

[muhammadmunir]

Respected sir your code is working well when I put duplicate data and press ENTER. But when i move to other cell through arrow keys it does not works.Secondly when we move to previous cell its row also deleted even it is happen to be unique value. Please advise how to fix this issue

[robertgryska]

Hi I have problem with this line
lastrow = Worksheets("Sheet1").Cells(Rows.Count, 4).End(x1Up).Row - Runtime error 1004 application defined or object defined error. Thx

[sallytong]

If it is possible the final action is not deleting the last row, but go to the number that has previously been entered. For example, if it is not ID number, it is fax number, I do not want to type duplicated fax number.

[ranjanbirla]

This code has an issue if you move up in column four (04), It will show it is a duplicate record and delete it. You keep moving the cursor in the upper row and it will keep deleting records. Which should not be the case.

[markarvin]

📢 This is nice, but there's a problem. If you mistakenly click on an entry that you don't want deleted, it automatically deletes that entry. Is there a fix out there for this? 😃

[Quoteminds]

Hello,
let say we have a id 12 and u right again in the below 12, then it shows duplicate and delete the cell which is great,
but when u enter again in blank cell the above data gets deleted also
please advise

[mukundpotdar]

Hi


In case if user try to copy and paste the data from Row 1 of Customer Id to Row 16 of Customer Id.
Can we prevent the duplicate data.