Hi,

I'm trying to figure out a way to loop through rows H23 to AI23 all the way down and deleting any rows which don't contain the value "Yes" in the same row on column G.
I also want to shift the bottom row up.

In simple terms, I want the code to check whether the row contains "Yes" in column G and if it doesn't, then delete it and move the bottom row up into its position, but if it does, move on to the next row and repeat the same process until Activecell.Value = "".

I just started learning macros a couple days ago so i apologize if this question is a bit elementary (i'm not very experienced with loops)