Does this help?
Sub kopapa()
If Sheets("Sheet2").Range("M" & Rows.count).End(3)(2).Value = "" Then
Sheets("Sheet2").Range("M" & Rows.count).End(3)(2).Value = Sheets("Sheet1").Range("B4").Value
Sheets("Sheet2").Range("N" & Rows.count).End(3)(2).Value = Sheets("Sheet1").Range("C4").Value
Sheets("Sheet2").Range("O" & Rows.count).End(3)(2).Value = Sheets("Sheet1").Range("B6").Value
Sheets("Sheet2").Range("S" & Rows.count).End(3)(2).Value = Sheets("Sheet1").Range("L61").Value
End If
End Sub
It assumes you already have data in M9 on sheet2.
Bookmarks