Records in between two specific dates easily can be filtered using
drop-down lists .
Drop-down lists were filled with unique values as ascending order using
Ado connection. Thus, it is easier to choose between the dates on the worksheet.
The filtered data can be copied to other sheet if it wished.
View it's video : https://youtu.be/baHyGS7i9n0
Sample file can be downloaded from Youtube link.C
--
excel_vba
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 399 |
Nodes: | 16 (2 / 14) |
Uptime: | 99:50:21 |
Calls: | 8,363 |
Calls today: | 2 |
Files: | 13,162 |
Messages: | 5,897,823 |