I have a form I'm creating for multiple users where they will have to use a drop down list in column A to select 1 of 5 options. In Column B users will also need to select an option from the list. Column B's list is expected to grow significantly, so what I would like to do is to provide some type of drill down of options in column b based on what was selected in column A.
For instance Column A options are:
GL
NA
LA
EM
AP
Column B options look like
2015-GL-nnn
2015-GL-BBB
2015-AP-THT
2015-NA-POO
If in cell A10 for example, a user selects GL, than I need for them to only see in B10, the options:
2015-GL-nnn
2015-GL-BBB
I'm using Excel version 15.0.4693 (Office 365)
Thanks in advance.
For instance Column A options are:
GL
NA
LA
EM
AP
Column B options look like
2015-GL-nnn
2015-GL-BBB
2015-AP-THT
2015-NA-POO
If in cell A10 for example, a user selects GL, than I need for them to only see in B10, the options:
2015-GL-nnn
2015-GL-BBB
I'm using Excel version 15.0.4693 (Office 365)
Thanks in advance.