Use Drop Down List to select multiple items

rfinnegan

Board Regular
Joined
Mar 15, 2005
Messages
172
Hi All:

I have a store performance report with about 120 rows of data spread across about 40 columns. I use t Drop Down list to select the specific store I want to look at (there's 80 stores).

The report relies on several WHATIFS to select the right data for the right store, and it works perfectly. But now I want to look at district performance (there are 7 districts). The raw data is only at the store level.

The only way I can think of doing it is to add a column to my raw data that identifies the district to which each store belongs, then add another WHATIFS to look for that condition.

Is there an easier or more efficient way to do this?

Thanks in advance.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,900
you dont use drop down to select many, you use a listbox.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,310
Messages
5,527,939
Members
409,793
Latest member
mavrik_stet

This Week's Hot Topics

Top