kadrleyn
Member
In this template ,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.
Source
- 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.
![Vba_fill_dates_to_script_dict_2.gif](https://eksi30.com/wp-content/uploads/2021/12/Vba_fill_dates_to_script_dict_2.gif)
Source