(Solved) – Filter: Hide all rows that are older than today

  • by
(solved)-–-filter:-hide-all-rows-that-are-older-than-today

I’ve tried, but couldn’t find any help for my task.

Given:
Columns A has future dates, Column B has values assigned to these dates.
Current date is the third variable.

Example:

Column(A) ——— Column(B)

01/01/2020——— Value 1

10/01/2020———– Value 2

Current date: 12/12/2020

Task:
I need a vba script that will hide rows that became past. So if current date is 05/01/2020, then my data would look like:

Column(A) ——— Column(B)

01/01/2020——— Value 1

Current date: 12/12/2020

I guess Range().Autofilter should be applied, but don’t know how to hide rows from past that are older than current date.

Leave a Reply

Your email address will not be published. Required fields are marked *