Data Filtering Using Drop Down Lists

The data in the selected column is filtered according to the selected value from the drop-down list on the userform (drop down lists are populated with unique and the sorted ascending values when userform is loaded). The text color of the cells in the filtered column is changed as blue.

Details & sample Excel file here

Excel VBA Filtering Between Dates On Worksheet

In this tutorial ,the records in between two specific dates easily can be filtered using drop-down lists on top side of sheet. Drop-down lists were filled with unique date values as from oldest to newest using two diffrent ways :

• First way , using Adodb Connection. 

• Second way , using Scripting Dictionary object and a user-defined function.

Thus, it is easier to choose between the dates on the worksheet.

The filtered data can be copied to other sheet if it wished.

➡️  Read More & Download Sample File