Hi Pam

See Chip's page
http://www.cpearson.com/excel/NoDupEntry.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Pam Coleman" wrote in message ...
how do i set up in my database that when a user is entering infor in a
column in excel, it will tell if there is a duplicate number. I do not want
duplicates.