Dynamic validation list
 

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 ?

Dynamic validation list
 

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.

Dynamic validation list
 

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.

Dynamic validation list
 

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.

Dynamic validation list
 

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 ?