Sub Übertragen()
Dim i As Long
Dim Titel(1 To 5) As String
Dim Datum(1 To 5) As String
For i = 1 To 5
With Worksheets("qu")
Titel(i) = .Cells(3 * (i - 1) + 1, 1).Value
Datum(i) = .Cells(3 * (i - 1) + 2, 1).Value
End With
Next
With Worksheets("Video neu")
.Cells(5, "O").Resize(5, 1) = Application.Transpose(Titel)
.Cells(5, "Q").Resize(5, 1) = Application.Transpose(Datum)
End With
End Sub
Sub Übertragen()
Dim wsZ As Worksheet 'Z für Ziel
Dim i As Long
Set wsZ = Worksheets("Video neu")
With Worksheets("qu")
For i = 1 To 5
wsZ.Cells(i + 4, "O") = .Cells(3 * (i - 1) + 1, 1).Value
wsZ.Cells(i + 4, "Q") = .Cells(3 * (i - 1) + 2, 1).Value
Next
End With
End Sub
Sub Übertragen()
Dim wsZ As Worksheet 'Z für Ziel
Dim i As Long
Set wsZ = Worksheets("Video neu")
With Worksheets("qu")
For i = 1 To 5
With wsZ.Range("O99999").End(xlUp)
.Offset(1, 0) = .Cells(3 * (i - 1) + 1, 1).Value
.Offset(1, 2) = .Cells(3 * (i - 1) + 2, 1).Value
End With
Next
End With
End Sub
...
With Worksheets("Video neu")
.Cells(ActiveCell.Row, "O").Resize(5, 1) = Application.Transpose(Titel)
.Cells(ActiveCell.Row, "Q").Resize(5, 1) = Application.Transpose(Datum)
End With
...
...
Cells(ActiveCell.Row, "O").Resize(5, 1) = Application.Transpose(Titel)
Cells(ActiveCell.Row, "Q").Resize(5, 1) = Application.Transpose(Datum)
...