This should work
Sub a()
Const shData As String = "Sheet1"
Const shDest As String = "Sheet2"
Dim wsData As Worksheet, wsDest As Worksheet
Dim rng As Range, Cell As Range
Dim LastRow As Long
Set wsData = Worksheets(shData)
Set wsDest = Worksheets(shDest)
Set rng = wsData.Range("A1", wsData.Cells(Rows.Count, 1).End(xlUp))
For Each Cell In rng
If wsData.Cells(Cell.Row, "G") = 22 And wsData.Cells(Cell.Row, "H") = 47 Then
LastRow = wsDest.Cells(Rows.Count, 1).End(xlUp).Row + 2
wsData.Range(wsData.Cells(Cell.Row, "A"), wsData.Cells(Cell.Row, "E")).Copy _
wsDest.Cells(LastRow, 1)
End If
Next Cell
Set wsData = Nothing
Set wsDest = Nothing
Set rng = Nothing
Set Cell = Nothing
End Sub
Bookmarks