Sub MyCopyMacro2()
Dim lr1 As Long
Dim r As Long
Dim lr2 As Long
Dim nr As Long
Application.ScreenUpdating = False
' Find last row with data on sheet 2
lr2 = Sheets("Sheet2").Cells(Rows.Count, "G").End(xlUp).Row
' Delete rows from sheet 2
If lr2 > 1 Then Sheets("sheet2").Rows("2:" & lr2).Delete
' Initialize first blank row number variables
nr = 2
' Find last row with data on sheet 1
lr1 = Sheets("Sheet1").Cells(Rows.Count, "G").End(xlUp).Row
' Loop through each row of data
For r = 2 To lr1
' See if date in column G is more than 60 days old
If (Date - Sheets("Sheet1").Cells(r, "G")) > 60 Then
' Copy to sheet2
Sheets("Sheet1").Rows(r).Copy Sheets("Sheet2").Cells(nr, "A")
' Increment new row counter
nr = nr + 1
End If
Next r
Application.ScreenUpdating = True
End Sub