I have the following code that selects rows where the criteria is met, I want to change this so it looks for rows in column 11 not containing X, y, z for example
If Worksheets("submissions").Cells(i, 11).Value ="Godders" And Worksheets("submissions").Cells(i, 21).Value= "" Then
I know i need to...