Hallo Mike1962
Wie gewüscht!
Gruß Nighty
[code]Global Index As Long[/code]
[code]Sub Kopieren()
Dim Daten As Object
Set Daten = Worksheets(1).Range(Worksheets(1).Cells(Index + 1, 1), Worksheets(1).Cells(Rows.Count, 1)).Find("Order ID:")
If Not Daten Is Nothing Then
Index = Daten.Row + 5
Worksheets(1).Rows(Daten.Row & ":" & Daten.Row + 5).Copy Worksheets(2).Range("A" & Worksheets(2).Cells(Rows.Count, 1).End(xlUp).Row + 1)
Call Kopieren
End If
Index = 0
End Sub[/code]