I have a problem with data validation. For example I have a drop down in the
cells where I can choose an area on a veh (drop down menu: Body, interior,
power train) in the next cell to the right I want a drop down that will lust
the specific items of the veh.
Example if I chose Body next cell will on show me body items only. If I
choose Interior next cell will only show me a list of interior parts only.

You will find exactly what you are looking for he
http://www.contextures.on.ca/xlDataVal02.html
Debra Dalgleish is the author, and you'll find that her site is a very
useful learning tool.
Rob


On Feb 1, 7:33 pm, dvidinov
wrote:
I have a problem with data validation. For example I have a drop down in the
cells where I can choose an area on a veh (drop down menu: Body, interior,
power train) in the next cell to the right I want a drop down that will lust
the specific items of the veh.
Example if I chose Body next cell will on show me body items only. If I
choose Interior next cell will only show me a list of interior parts only.