Looking for help. The column below shows dates in the mm/dd/yyyy format, and can cover a range of time spanning several years. I want to write an Excel VBA script to identify the month specified in a different worksheet (Titled "REF"), and delete all rows that are not within that month/year.
For example, I'm measuring August, 2022 right now - and only want to keep the rows of data that begin with 8, and end with 2022.
REF worksheet example:
Thanks!
For example, I'm measuring August, 2022 right now - and only want to keep the rows of data that begin with 8, and end with 2022.
REF worksheet example:
Thanks!