Drop-down list varies based on input

[kaldrazidrim]

All fields in column E of sheet 1 have data validation for drop downs from a list that is specified on Sheet 2. This list is called "Major".

The major list is

1- Color

2- Machine Problem

3- Eyemark, etc...

Now, I have other lists specified on Sheet 2 called "Minor" lists.

If I select "1- Color" from the Major drop-down list in E, I want the adjacent cell in column F to be the corresponding "1- Minor" drop-down list.

If I select "2- Machine Problem" from the Major drop-down list in E, I want the value in F to be a drop down list that corresponds to that value, namely "2-Minor".

In other words, based on the input in E (from a drop-down), I want the value of F to change to various corresponding drop-downs.

[jeffreybrown]

Hello & Welcome to the Board,

This might help.

http://www.excelforum.com/2443145-post2.html

[jeffreybrown]

Please take a few minutes a read the forum rules about cross posting.

http://www.mrexcel.com/forum/showthr...=1#post2561755