A data validation list that opens another list and another until right thing selected.

FORDFAN

New Member
Joined
Nov 2, 2016
Messages
18
Hi.
Am confused here.
I would like to create a data validation drop down list that when one of 4 things are selected, it brings up another list, select an option and bring up a final list.

Example: Drop down list one would have Region 1, Region 2, Region 3, Region 4.
By selecting Region 2, it opens another list that gives me Zone 1, zone 2, Zone 3, Zone, 4.
Say I select Zone 3, it gives me BOB (out of BOB, JOHN, SANDY, CHRIS)

Can anyone help or point me to a tutorial to do this.

Thanks
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
Select the cells you want to validate. The click the data validation button or press Alt+U to search for "data validation" (translate to your installed language).In the wizard choose "list" in the first option, and provide your list in the next one. Your list would simply be this Region 1, Region 2, Region 3, Region 4
No = or "
If you only get this option "Region 1, Region 2, Region 3, Region 4" you need to provide another separator sign.
 
Upvote 0
Hi.
Thanks for the quick reply. I don't think that is quite what I'm after.
An example would be like the 'Conditional Formatting' menu on Excel where you hover over it, it brings up a sub-menu, you select from the sub-menu and then select the thing you want.
That's what I'd like to do but in a data validation cell.
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,024
Members
448,543
Latest member
MartinLarkin

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
Back
Top