Need assistance with Macro to stop duplicate entries

[tfilipe]

Hi all,

Need to stop duplicate entries into the database sheet, is this possible in VBA?

Would like to set it in column J (Mobile ph), of the attached workbook.

Many Thanks

[Logit]

.
Change your CONTACTS worksheet macro with this :

Please Login or Register  to view this content.

[tfilipe]

Thanks for the fast feedback Logit, I entered a duplicate and it allowed it

[tfilipe]

I put it on the database sheet instead and it intercepted the duplicate entry but still allowed it!

[Logit]

.
Using the CONTACTS sheet and the last entry in the column ( 936 555 333 ) ... if you go to the empty line below it ( in J column) and re-enter that same number, in the same pattern, the macro functions.

Same pattern : 936 *space* 555 *space* 333

If you enter the number in any other pattern the macro will not work.

It also works if you paste the number in the cell.


?????

[tfilipe]

Hummmm..! maybe I didn't explain myself properly.

Yes If I select column J in the last row, the Macro does indeed work! however the order of data entry or updating is a bit different! let me explain....

If you select a contact, the info gets loaded in cells I6 through to M12, on those cells is where any changes are made and than pressing the update button and one of those changes was a number that already exist! the Macro doesn't seem to work, Also if you press the NEW button and enter the info in cells I6 through to M12 and the Mobile ph is a duplicate it also does not work!

Entering data directly on the last row Is not intended, the process of the workbook is as follows, data is entered or edited in the cells I6 through to M12 and than copied to the database sheet after pressing the save button, and in turn the list on the Contacts page gets refreshed from what is on the database!

So I am not really sure where (which sheet) or Module should this macro be put into!!!!

[Logit]

.
Hmmm.... Ok ... that's waaaay different from what was originally described.

Let me think about it. I'll get back with you. It's late here now (midnight). Time for sleep.

[tfilipe]

Hi, No drama Logit, whenever u find the time....

[Logit]

.
Ok ... this macro will check for dupes in Col D (Mobile Phone #) of the DATABASE sheet.

Please Login or Register  to view this content.

You could add to it to check other columns as well.

[tfilipe]

Thanks very much for you effort Logit.