Data Validation - 2007 - Help

[Superstar31]

I currently am using excell 2007 data validation.

here is my 2nd problem

I Have two trees I need to spil with dropdown

Meaning if I have 2 paths to choose from

option 1 and option 2

option 1 contains the numbers 1-5

option 2 contains the numbers 6-10

When using a data validation if I chose 1, i see 1-10 if i choose 2, i see 1-10

Is it possible to have someone choose 1 and see only 1-5 and if they choose 2 they only see 6-10 with a data validation?

Thanks and hopefully that makes sense

 

[Stephan Hoenselaar]

Superstar,
Create a column with the heading Selection (columnA), this column contains two cells Scenario1 (A2) and Scenario2 (A3) .
Create two columns with heading Scenario1 (columnB) and fill with 1-5 (B2:B6) and Scenario2 (columnC) and fill with 6-10 (C2:C6). Select cell B2:B6 (1-5) click insert->name->define... and name this rage Scenario1. Select cell C2:C6 (6-10) click insert->name->define... and name this rage Scenario2 (in this case it is essential that the names in column A exactly correspond with the naming of the ranges!!!).

Now select Cell D1 click: Data->Validation select list and range is A2:A3. Create a 2nd validation in Cell D2 click: Data->Validation select list and enter in the Source field "=indirect(D1, true)".

Now after you select say scenario1 in the first validated cell the selections in your second validated cell should be 6-10.

Good luck!

 

[Superstar31]

Superstar,
Create a column with the heading Selection (columnA), this column contains two cells Scenario1 (A2) and Scenario2 (A3) .
Create two columns with heading Scenario1 (columnB) and fill with 1-5 (B2:B6) and Scenario2 (columnC) and fill with 6-10 (C2:C6). Select cell B2:B6 (1-5) click insert->name->define... and name this rage Scenario1. Select cell C2:C6 (6-10) click insert->name->define... and name this rage Scenario2 (in this case it is essential that the names in column A exactly correspond with the naming of the ranges!!!).

Now select Cell D1 click: Data->Validation select list and range is A2:A3. Create a 2nd validation in Cell D2 click: Data->Validation select list and enter in the Source field "=indirect(D1, true)".

Now after you select say scenario1 in the first validated cell the selections in your second validated cell should be 6-10.

Good luck!

Not sure I understand, any chance you can add a picture?


GOT IT!!!!!!

THANKS