Drop down list

Occasional Visitor

I would like to create a drop down list that when you select a certain item from the dropdown menu, it has all the data along with it. Does that make sense? For example: Alaska is the item that would be selected, but I want it to show the data from the cells that fall under Alaska -

 

Alaska
01 AK Introduction
02 AK Components of Tank Systems
03 AK Release Detection and Reporting
04 AK State Requirements
05 AK Temporary and Permanent Closure
06 AK Operator Training
07 AK Class C Operator
08 AK Inspections
1 Reply

@aforbes26 

Hi, if you have Excel 365 then this is possible. You have to create a named area with the name "Alaska" for the content Alaska. Then you have to create a list for your dropdown. This must be text. So write in the cell: '=Alaska

Then you can select this name in the dropdown. There is just the "=" in front of the name.

 

dscheikey_0-1666365846076.png

 

After the selection, the area spills down.

 

dscheikey_1-1666365872577.png