jmaocubo
01-28-2011, 10:22 AM
Hi
I wonder if is possible to excluded a item (from a validation date list) after been used in another cell.
Ex:
In sheet1 i have a list in A1:A
A1 - Text1
A2 - Text2
A3 - text3
A4 - ...
....
In sheet2: cells C15:C25 if in cell C15 i select from the dropdown list "Text3" when i select in C16 the dropdown list shoud not have the tex3... and so on
The items from the list only can be selected one time (no duplicated)
Thanks in advance and sorry for my bad english
I wonder if is possible to excluded a item (from a validation date list) after been used in another cell.
Ex:
In sheet1 i have a list in A1:A
A1 - Text1
A2 - Text2
A3 - text3
A4 - ...
....
In sheet2: cells C15:C25 if in cell C15 i select from the dropdown list "Text3" when i select in C16 the dropdown list shoud not have the tex3... and so on
The items from the list only can be selected one time (no duplicated)
Thanks in advance and sorry for my bad english