• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel VBA Sort Dates From Oldest To Newest

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.

Vba_fill_dates_to_script_dict_2.gif


Source
 
Back
Top