Multiple Selection Drop Down Box

blchan

New Member
Joined
Dec 17, 2013
Messages
4
I have a list of buildings and for each building there are certain systems associated with them. The systems are, for instance: heating, cooling, plumbing, elevators. I would like to make a list where I am able to choose multiple buildings and choose specific systems within those buildings. For instance,
BuildingSystem
AHeating
Cooling
CHeating
Cooling
Plumbing
DHeating
Cooling
Elevators
Plumbing

<tbody>
</tbody>
where under the building cell (A1), I want to be able to select any combination of buildings from a list A to Z, and for each building, an associated set of systems (in the example, I randomly chose A to have 2 systems, C to have 3, and D to have 4), where there are a finite number of systems (say, ten).

From the way I see it, the table will need to be able to automatically adjust itself based on how many buildings are chosen along with the particular systems within that building. Is there a code that will allow me to achieve what I need?

Thanks in advance.
 
Last edited:

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,171,466
Messages
5,875,671
Members
433,147
Latest member
Nav05

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