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
Solution
For the solution to your problem pls chk...
http://excelexperts.com/node/1138
filter rows
this requires VBA..
I can tell you the methodology:
Rgds
Nick
more on toggling autofilter here:
32. VBA Tips - Turn Off Autofilter