I can see why this is pasted to row 3 and not 2 in ws4? I need a loop to go through all the columns A:E in ws1 with values to ws4.
Sub test12()
Dim ws1 As Worksheet
Dim ws4 As Worksheet
Set ws1 = ThisWorkbook.Sheets(1)
Set ws4 = ThisWorkbook.Sheets(4)
ws1.Range("A:E").Rows(2).Copy Destination:=ws4.Range("A" & 2).Rows(2)
End Sub