Hello,
I have 22 000 rows of data in which one of columns is date. For example: from 01.01.2021 to 02.02.2022.
My question. How can I use excel if I want to extract data for desirable range: I want get data from 03.03.2021 - 06.05.2021, or just 05.05.2021 - 05.05.2021 (one day), and so on.
My idea is create VBA where user choose files, gather data and then he can generate reports by selecting different dates and compare others data.
I found some youtube tutorials, but they use dropdown list functionality what is not the option, because in this case I would get probably 365 item list.
I have loaded a picture how I imagine user should select dates for report data. So my goal is find put how can data be extracted by different date, not only 1 date, but range.
Bookmarks