Hi,
I have a combo box in Sheet 1, that has a date picker to select the date.
In Sheet 2, I have dynamic rows of data, this data changes, there can be different years, in the date range
Column A has the dates, dd/mmm/yy
I would like to move all the rows that the equal the month and year of the date from the date picker month/year, from Sheet 2 to Sheet 3.
If I select 23/2/2018, then all the rows that have a February 2018 date in Sheet 2, copied to Sheet 3.
Thanks in advance
Cfer
I have a combo box in Sheet 1, that has a date picker to select the date.
In Sheet 2, I have dynamic rows of data, this data changes, there can be different years, in the date range
Column A has the dates, dd/mmm/yy
I would like to move all the rows that the equal the month and year of the date from the date picker month/year, from Sheet 2 to Sheet 3.
If I select 23/2/2018, then all the rows that have a February 2018 date in Sheet 2, copied to Sheet 3.
Thanks in advance
Cfer