Hello and thanks.
I have four cells on a Sheet1 ("T39", "T47", "T57", "N61:N62") that i would like to copy and paste to the next available row on Sheet2 in range ("N:Q").
ElseIf Cells(i, 3).Value = "" Then
Sheets("Sheet 1").Range("T39", "T47", "T57", "N61:N62").Copy
Sheets("Sheet...