Filter rows based on drop down values

Greetings!!

I want to filter the rows based on the dropdown value/values. For example a cell($A3) contains list of values aaa,bbb,ccc then I want filter all the rows from row 30 to 300 based on the selection of earlier dropdown. a column in the row would contain one of the value from the given dropdownlist.

Quick help would be appreciated.

Thanks,
Ashok

Vishesh's picture

Solution

For the solution to your problem pls chk...

http://excelexperts.com/node/1138

Nick's picture

filter rows

this requires VBA..

I can tell you the methodology:

  • capture the change event on the sheet
  • on change, parse the value of the input cell
  • check the filtermode
  • clear the filter, then readd it
  • filter on the parsed values

Rgds

Nick

 

more on toggling autofilter here:

32. VBA Tips - Turn Off Autofilter