Data validation master cell

  • Thread starter Thread starter drewdog
  • Start date Start date
D

drewdog

Is it possible to change what list is in a cell by selecting the name o
that list from a "master" cell?

For instance, say the master cell is A1, and it's validation lis
contains the list "cats, dogs, horses".

The list in B1 would be based on what list is selected in A1. Fo
instance, if A1 was set to "cats", then the choices in B1 would b
something like, "Calico, Tomcat, housecat, Siamese".

What I really want to do though, is only have one "master" cell an
have dependent cells that change depending on the master.

So, if A1 is the master, and you set to cats, you get the above list.

If you then change the master to Dogs, and click in ANOTHER dependen
cell (not B1), it will say "lab, mastif, doberman".

When I try to do it, it won't "reset" and control other cells afte
you've used it once.

Dre
 
Hi Drew,

Assume a named range called 'Animals' with entries 'cats', 'dogs', 'horses'.
Then set up named ranges called 'cats', 'dogs', 'horses' with their own
entries.
(to set up named ranges use Insert - Name - Define)

In cell A1 set data validation to List and Source '=Animals' (no quotes).
In cell A2 set data validation to List and Source '=INDIRECT($A$2)' (no
quotes).

Ed FErrero
http://edferrero.m6.net
 
Back
Top