See http://www.contextures.com/xlDataVal03.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"stabilo" wrote in message
...
I hope I will expose my question clearly :

I have a validation list with, let's say, the following values :
A
B
C
D

Cells from a column are validated against this list. What I would like is
everytime that everytime a value is used, this value si no more available
in
the list. Let'w say I pickup C, C is not available for next cell.

Is this doable in a way ?