Flow down Drop Down List

volsfan210

New Member
Joined
Jul 24, 2024
Messages
14
Office Version
  1. 365
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.



CompanyBS
System
SubSystem
Department
Resource Type
FY
DATE
 
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.
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,919
Members
453,767
Latest member
922aloose

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