Data between two dates easily can be filtered using drop-down lists .Macro codes fill as ascending order, unique values into drop-down lists through Adodb connection .Then, two dates(start date,end date) are selected from two drop-down list . Data in between this two dates are listed using autofilter method on worksheet.
In this template, we created a userform that automatically displayed to make it easier to enter data into the worksheet. The userform contains dependent combo boxes( combobox in which the list depends on the selection made in another combobox),textbox and button.
In workbook,Scripting Dictionary Object was used to fill in comboboxes :
Set SD = CreateObject(“Scripting.Dictionary”)
For Each x In Supplier
SD(x) = “”
ComboBox1.List = SD.keys