Flow down Drop Down List

[volsfan210]

Hi -

Below is currently a listing of options to pick for a spend plan. Each one of these options has a drop down list to choose from

What I am looking to do is when the person selects the company (BS, BE, BC, etc) that the next drop down (system) only shows the applicable values in the drop down that applies to BS then when they go to subsystem that will only show the applicable option based off the Company & System.

and so on through the entrie thing.

Company	BS
System
SubSystem
Department
Resource Type
FY
DATE

 

[myall_blues]

What you need is what is known as a 'dependent drop down list'. Have a look at this Exceljet page for a good description of how to go about it.

Note though that as you go deeper into the list (for example Subsystem being dependent on both Company and System, and Department being dependent on all three company, system and subsystem it becomes increasingly complex. If your systems are unique to each company then you can treat the subsystem as a simple dependency of the system, but if not it will be more difficult.