M
Michael Hudston
I would like to set a validation list on a column based on the value of the
adjacent cell in the other column, but can not seem to figure out how to do
this.
I have the following named ranges.
Category Which contains :- Capacitor, Resistor, Diode, Connection and others.
Capacitor Which Contains :- Air Trimmer, Variable, Fixed, Surface Mount Etc
Resisitor Which Contains : Variable, Wire Wound Etc
I also have named ranges for Diodes, Connections and other items that appear
in the Category List.
What I am trying to achieve is
Depending on the Value I select for Column A from the Category List, then I
want the Adjacent Cell in Column B to validate against the relevant list.
Ie if in Column A i select a category of Capacitor, then the Validation in
the adjacent cell should be limited to the list in named range "Capacitor"
Where do I even start?
Help Please.
adjacent cell in the other column, but can not seem to figure out how to do
this.
I have the following named ranges.
Category Which contains :- Capacitor, Resistor, Diode, Connection and others.
Capacitor Which Contains :- Air Trimmer, Variable, Fixed, Surface Mount Etc
Resisitor Which Contains : Variable, Wire Wound Etc
I also have named ranges for Diodes, Connections and other items that appear
in the Category List.
What I am trying to achieve is
Depending on the Value I select for Column A from the Category List, then I
want the Adjacent Cell in Column B to validate against the relevant list.
Ie if in Column A i select a category of Capacitor, then the Validation in
the adjacent cell should be limited to the list in named range "Capacitor"
Where do I even start?
Help Please.