Advanced Filtering With Drop Down Lists
In this template ,other page (second sheet) was used to filter data. Also ,drop-down lists (Data_Validation_List) are used to facilitate filtering.
The drop-down lists are filled with unique values. Also named ranges are used as sources of data validation (Col1,Col2,Col3 etc.).
When there are changes in the data sheet, may be necessary updating the unique values. so when the book is opened ,”unique values” macro runs automatically :
Private Sub Workbook_Open()
Or unique values can be updated by pressing the button on the “Unique Values” page.
ActiveWorkbook.Names.Add Name:=”Col1″, RefersTo:=”=OFFSET(Unique_Values!$A$2,0,0,COUNTA(Unique_Values!$A:$A)-0)”