Home » Forums » Open Source Learning Center » Question and Answer

Filter rows based on drop down values

Submitted by ashokmsis on 8 April, 2011 - 15:38

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

‹ Import/transfer data from worksheet to workbook in vba what is the function name for this calculations ›
»
Nick's picture

filter rows

Submitted by Nick on 9 April, 2011 - 14:07.

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

»
Vishesh's picture

Solution

Submitted by Vishesh on 10 April, 2011 - 07:38.

For the solution to your problem pls chk...

http://excelexperts.com/node/1138

»