VBA Excel: Filter by Month/Year Period
Lena
-
yg_be Posted messages 23437 Registration date Status Contributor Last intervention -
yg_be Posted messages 23437 Registration date Status Contributor Last intervention -
Hello,
I'm working with Office 2013, and I have a table with different data, including dates consisting solely of the month in one column (e.g., "April" in column C) and the year in the next column (e.g., "2018" in column D). See the following link: https://www.cjoint.com/c/IIdnD3pRxGX
I would like to program a filter using VBA to extract data from a specific period, for example: from April 2018 to February 2019. I tried the auto filter, but it doesn’t recognize the months as dates, but rather as text, so it doesn't offer me a chronological filter.
Does anyone have any idea how to proceed to get closer to or even achieve the expected result? Any ideas would be welcome!
Thank you for your help!!
I'm working with Office 2013, and I have a table with different data, including dates consisting solely of the month in one column (e.g., "April" in column C) and the year in the next column (e.g., "2018" in column D). See the following link: https://www.cjoint.com/c/IIdnD3pRxGX
I would like to program a filter using VBA to extract data from a specific period, for example: from April 2018 to February 2019. I tried the auto filter, but it doesn’t recognize the months as dates, but rather as text, so it doesn't offer me a chronological filter.
Does anyone have any idea how to proceed to get closer to or even achieve the expected result? Any ideas would be welcome!
Thank you for your help!!
1 answer
-
yg_be Posted messages 23437 Registration date Status Contributor Last intervention Ambassadeur 1 588
Hello, can you explain the expected result? What do you mean by "extracting" the data? Why VBA? Do you already have part of the VBA, where it would just be a matter of adding the "filter"?
It is often unnecessary to "program a filter," as a filter is rather used manually. When programming, there are other techniques to only process part of the data.
