Data Validation - 2007 - Help

Superstar31

Active Member
Joined
Nov 10, 2005
Messages
496
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
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Stephan Hoenselaar

New Member
Joined
Jul 11, 2007
Messages
40
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

Active Member
Joined
Nov 10, 2005
Messages
496
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
 

Watch MrExcel Video

Forum statistics

Threads
1,130,443
Messages
5,642,159
Members
417,258
Latest member
amk1979

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top