Hallo Rainer,
der Code sieht so aus:
[code]Sub kopieren()
Dim i As Integer, Blatt As String
Application.ScreenUpdating = False
Sheets(Array("1", "2", "3", "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", _
"16", "17", "18", "19", "20", "21", "22")).Select
Sheets("1").Activate
Columns("A:Q").Select
Selection.ClearContents
Sheets("Anmeldung").Select
For i = 1 To Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
On Error Resume Next
Blatt = Sheets("Anmeldung").Cells(i, 14)
Worksheets("Anmeldung").Range("A" & i & ":R" & i).Copy
Sheets(Blatt).Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).PasteSpecial _
Paste:=xlValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Next
End Sub[b]
Freundliche Grüße
Tom