Use VBA to select a range based on the first cell of todays date in Axx and the last row column Fxx?

[mvfsullivan]

Hey all, first of all, you are amazing for helping everyone. There are tons of people helping out and I cant wait to build my skills to the point where I can do the same.

So to super simplify my set up, I have users reporting issues based on date on a file I've been using for months so it has over 4,000 entries. To make my daily stat reporting easier to manage I have a condition that highlights the current day green. I manually paste all of the current days info into a table which pulls stats into a presentable thing I email myself just for some sort of history. I want to automate this last step.

So based on that, is there a way to use VBA to search the table for todays date, select the first cell of the date column A, then finish selecting off the rest of the table? The only issue is some of the entries past the first todays date can sometimes include older dates because the user forgets to report the issue and does it the next day, choosing the previous date as the time of the issue. This is why I am thinking of just grabbing the first todays date and then the last row of column S (which is the furthest column needed to pull stats).

 

[Fluff]

Duplicate to: https://www.mrexcel.com/board/threa...o-the-last-row-and-a-specific-column.1191333/

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.