Previous Topic Next Topic

Restricting drop down box values to filtered

Closed
Seahawks - Aug 22, 2010 at 05:51 PM
rizvisa1 Posts 4478 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?
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 24, 2010 at 08:25 AM
See if this helps
https://ccm.net/forum/affich-269392-dropdown-lists-in-excel-2007
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
Instagram is blocking all the comments I'm doing
Lucile -
Lucile -

4 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response