Create multiple dropdowns where you can select more than 1 from dropdown, options available in dropdown is dependent on previous selection.

stacyloufurious

New Member
Joined
Dec 21, 2017
Messages
1
I'm working with data where I have 2 areas, each with multiple regions, then each region with multiple markets. I'd like to have the user select from the 1st dropdown of 'areas', then the regions available to choose from in the next dropdown will be dependent on the area(s) selected, and the markets are then dependent on the region(s) selected. This is the base.

With that, I want the user to be able to select 1 or more from each dropdown when needed and if they select any value in error they should be able to remove that one value without erasing everything they may have already selected for that field.

Any direction, help on this is greatly appreciated!!!
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

PilsburyKush

New Member
Joined
Jan 16, 2018
Messages
3
This can be done with an IF statement within your data validation parameters of your drop down list. But, you cannot multi-select in a drop down menu. Let me know if you need additional help.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,704
Members
414,401
Latest member
grenona2020

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