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

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Forum statistics

Threads
1,137,063
Messages
5,679,401
Members
419,825
Latest member
MegastarMagus

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