Robert1688
Agricultural
- Jan 13, 2007
- 14
Can a validation list in a cell is controled by another cell?
For example: if in cell "A1" is "Fruit", then the validation list in cell "B1" will be "Apple", "Pear", "Orange"; if in cell "A1" is "Furniture", the the calidation list in cell "B1" will be changed to "Table", "Chair", "Sofa".
I believe that will do a lot help to some people.
For example: if in cell "A1" is "Fruit", then the validation list in cell "B1" will be "Apple", "Pear", "Orange"; if in cell "A1" is "Furniture", the the calidation list in cell "B1" will be changed to "Table", "Chair", "Sofa".
I believe that will do a lot help to some people.