Have a look he
http://www.contextures.on.ca/xlDataVal03.html

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Kameca" wrote in message
...
Is there a way to have a list that will eliminate a value once it is
already
used in a group of cells?