.
Hmm ... not certain what to advise. I made the change here to column T and it functions well.
Option Explicit
Sub cpyPaste()
Dim i As Integer
For i = Cells(Rows.Count, "A").End(xlUp).Row To 2 Step -1
If Sheets("Master Data").Range("T" & i).Value = "query" Then
Sheets("Master Data").Rows(i).Copy Sheets("Queries").Range("A" & Rows.Count).End(xlUp).Offset(1)
End If
Next i
End Sub
I presume you are still seeking the term query ?
If the term has changed you will need to change it in the macro code as well.
Bookmarks