Hi, I am looking for a macro that would progressive filter a table by the values of the selected column. i.e. At first run it would filter by the first value of the column, at second run by the second value of the column etc.
I found a great solution in this link: http://www.excelforum.com/excel-prog...g-value.html#6
However the main file for which I would use the macro, contains dates and I would like to auto-filter by progressive YEAR_MONTH, (Now the code does not auto-filer even on Day_Month_Year level).
It would be good if the code would automatically recognize the active column without specifying it in VBA.
I attach a simplified file as example, hoping that the macro could progressive filter by September_2105, October_2015, November_2015, December_2015, January_2016, etc.
Many many thanks for your support,
Kr, estgas
Bookmarks