Restricting drop down box values to filtered

Closed

Seahawks - Aug 22, 2010 at 05:51 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 24, 2010 at 08:25 AM

Hello,
How do I format a drop down list box that captures only filtered values and changes the values depending the filters? I have a spreadsheet that has about 8,000 rows and about 20 columns. I have filters on each of the columns and would like to create a list box that displays only the filtered values. Can this be done?

Restricting drop down box values to filtered
Tweak box - Download - App downloads
Based on the values in cells b77 b81 ✓ - Excel Forum
My yahoo mail box - Yahoo Mail Forum
Business in a box - Download - Other
How to get rid of white box on computer screen ✓ - Monitor Forum

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Aug 24, 2010 at 08:25 AM

See if this helps
https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007

Subscribe To Our Newsletter!