Find rows to delete with a macro based on cell content

I've written a macro to create 2 worksheets containing data from a 3rd worksheet. My macro works fine, but it's "stupid". I manually selected rows on new worksheet for deletion. I can't figure out a way to have the macro delete the rows based on the contents of the cell in column A. How can I have the macro automatically determine which rows to delete? I've attached a copy of the spreadsheet with dummy data so you can see what I'm trying to do. I can't use a formula to do this because it won't pick up the background color formatting. Also, each entry on the first sheet could have anywhere from 1-3 rows depending on the type of change being documented. The only constants are the contents of the cells in column A.

Thanks.

Hi mkraffert

Welcome to the Forum!

I'd have to say, if

My macro works fine

then it's not

"stupid"

It may need to be cleaned up a bit and we can help you with that. Won't be me tonight...perhaps another...if not, I'll look at it tomorrow.

Hi mkraffert

Here's new Code for Sub Dev()

Please Login or Register  to view this content.

Why don't you play with Sub Threshold()...run into troubles let me know.

You're welcome...glad I could help. Thanks for the Rep.