PDA

View Full Version : Solved: Auto find duplicate entries



debauch
01-18-2006, 12:06 PM
Ok vbax superhero's,
I think this one should be fairly easy, but I am not sure where to start. I am looking to implement a macro the will catch duplicate employee id's or ssn #'s. I create logins for users, and do not want to make duplicate IDs for the same user, and to have it catch this right away would be awsome. Can anyone attach a small working file with an example to get me started? Thanks.

mdmackillop
01-18-2006, 12:24 PM
Have a look at the following.

debauch
01-18-2006, 12:53 PM
thanks for the response.

I typed in 100048034 over 5 times, and it never caught the duplicate(s), but when I type what is already previously there, it says "ID used", so it does and doesnt work?

I will try the code you have there and mess with it a bit.

Is it possible, to have a macro run a whole column and check for duplicates ? I could put in a button, and after adding new users, I could just run the code, and have it search for the dups?

debauch
01-18-2006, 12:56 PM
Sorry, my fault. I trimed the column, and it picked up the number. Cool. So, can we make it compare a whole column?

mdmackillop
01-18-2006, 01:11 PM
If you want to check a column for duplicates, you can't do much better than this tool.
http://members.iinet.net.au/~brettdj/

mdmackillop
01-18-2006, 01:17 PM
My code will not find existing duplicates as the add-in will, but it will prevent new duplicates being created. It really depends upon your sheet layout to determine the best method of data entry/checking. If you can post a sanitized sample, maybe we can advise further.

debauch
03-27-2006, 04:24 PM
If you want to check a column for duplicates, you can't do much better than this tool.
http://members.iinet.net.au/~brettdj/ (http://members.iinet.net.au/%7Ebrettdj/)

Perfect. Solved.