Wypróbuj kod: Sub kopiowanie()
Dim kolumna_zapisu As Long, wiersz_zapisu As Long
With Sheets("DQR Logbook")
kolumna_zapisu = .Cells(11, .Columns.Count).End(xlToLeft).Column + 2
.Range("C11:D33").Copy .Cells(11, kolumna_zapisu)
End With
With Sheets("Over Inspection Record")
wiersz_zapisu = .Cells(.Rows.Count, 1).End(xlUp).Row + 2
.Range("A3:M10").Copy .Cells(wiersz_zapisu, 1)
.Range("B" & wiersz_zapisu) = "='DQR Logbook'!R11C" & kolumna_zapisu & ""
.Range("I" & wiersz_zapisu) = "='DQR Logbook'!R12C" & kolumna_zapisu & ""
.Range("M" & wiersz_zapisu + 1) = "='DQR Logbook'!R14C" & kolumna_zapisu & ""
End With
End Sub |