Hello.
In my workbook, column A contains dates, which can be repeated.
The table is not sorted (and can't be) on column A.
I need a macro that will find the last instance of today's date, and select the cell (or table row) immediately under.
I haven't been able to find a solution for this, as all I could find only works if there is only 1 occurance of today's date (as in calendars).
Hope someone can help me on the way here.
Thank you in advance.
maps
In my workbook, column A contains dates, which can be repeated.
The table is not sorted (and can't be) on column A.
I need a macro that will find the last instance of today's date, and select the cell (or table row) immediately under.
I haven't been able to find a solution for this, as all I could find only works if there is only 1 occurance of today's date (as in calendars).
Hope someone can help me on the way here.
Thank you in advance.
maps
Last edited:
