I have spent sometime searching for why this isn't working but to no avail...
What I am trying to do is loop through a column of data until condition 1 is met then check if condition 2 is met 4 cells to the left. Below is the code, if I change the "And" to "Or" it works when either condition is met but if it is "And" it doesn't. Thank you for the help!
Range("G5").Select
Do
If Selection.Value = Range("M4") And Selection.Offset(0, -4) = Range("I4") Then
Range(Selection.Offset(0, -4), Selection).Copy
Else
Selection.Offset(1, 0).Select
End If
Loop
Bookmarks