Macro That deletes rows based on date and text

I'm slowly trying to automate a weekly report that I put together every Monday (sometimes Tuesday). The example I attached is from Monday 7/3 and hope to be able to use this macro on 7/10 or 7/11.

I need a macro that will delete the row if the text in Column H starts with "auto" ("auto*" if was used in a formula) AND the date in column C is the previous Thursday thru Current date (6/29,6/30,7/1,7/3,7/4) .

In this example, 8 rows should end up being deleted. This data is usually 15,000 ish rows long and the dates update every week.

Thank you so much in advance

No its a little different, previous thread was looking for any text in the cell and the date as criteria for deletion. That was a different part of the report as well

This Thread I am looking for cell H to start with "auto" and the same date criteria for deletion. I could probably reuse the previous code to search for the date but I have no idea how to look for a specific starting text

Originally Posted by toastmaster12

the date in column C is the previous Thursday
thru Current date (6/29,6/30,7/1,7/3,7/4)

So you want to not delete 6/28, 6/27, 6/20 and 6/1 ?

Originally Posted by Marc L

So you want to not delete 6/28, 6/27, 6/20 and 6/1 ?

For for this example yes, the goal would have the previous Thursday -next Tuesday dates that meet the text criteria deleted. This example is from 7/3 so 6/28 and older should not be deleted

This should be dynamic now so if your data goes past 25k rows.

Please Login or Register  to view this content.