Hi Michael

Take a look at
http://www.contextures.com/xlDataVal15.html

--

Regards
Roger Govier

"Michael Hudston" wrote in
message ...
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.

__________ Information from ESET Smart Security, version of virus
signature database 5172 (20100604) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 5172 (20100604) __________

The message was checked by ESET Smart Security.

http://www.eset.com