New member here!
I've had good luck with some code written to hide rows when the cell in column "A" is blank(for a certain range of rows), but I tried to modify it to hide rows that have "Complete" in column "D" and it works, but only after freezing excel for a time.
Here's my original code...