Give this a look...

http://www.cpearson.com/excel/NoDupEntry.htm
--
HTH...

Jim Thomlinson


"cbrd" wrote:


I have a column on a worksheet. In this column people will be entering a
number. I was wondering how I would go about disallowing someone to
enter a number that allready exists in the column, and to pop up a
message or something when they try.


--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=497975