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 ?

See

http://www.contextures.com/xlDataVal02.html


In article ,
"stabilo" wrote:

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.

Thanks, it is interesting but not quite what I'm looking for. Here the idea
is to remove picked items from the validation list as soosn as they are used

Another idea ?

"JE McGimpsey" wrote:

See

http://www.contextures.com/xlDataVal02.html


In article ,
"stabilo" wrote:

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.

sorry, ovelooked the doc, it is exacly what I need

"stabilo" wrote:

Thanks, it is interesting but not quite what I'm looking for. Here the idea
is to remove picked items from the validation list as soosn as they are used

Another idea ?

"JE McGimpsey" wrote:

See

http://www.contextures.com/xlDataVal02.html


In article ,
"stabilo" wrote:

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.

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 ?