Sub findred() Dim maxRow As Long maxRow = Sheet1.[A65535].End(xlUp).Row Sheets("sheet2").Cells.ClearContents Sheet1.Range("a1:c2").Copy Sheets("sheet2").Cells(1, 1) For t1 = 1 To maxRow If Cells(t1, 3) <> "" And Val(Cells(t1, 3).Value) > 50 Then Range(Cells(t1 - 2, 1), Cells(t1, 1)).EntireRow.Copy Sheets("sheet2").Cells(Sheets("sheet2").[a65536].End(xlUp).Row + 1, 1) End If Next End Sub