Salut Renee
Besten Dank schon mal. Hier der Code (ziemlich lang :-) )
Sub ÜBERNEHMEN()
ACHTUNG = MsgBox("Alle Daten korrekt?", vbYesNo, "ÜBERNEHMEN")
If ACHTUNG = vbYes Then
Range("B1").Select
Selection.Copy
Range("B3").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("B1").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("A2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F1").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("U2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F2").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("V2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F3").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("W2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F4").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("X2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F5").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("Y2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F6").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("Z2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F7").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("AA2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F8").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("AB2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F9").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("AC2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F10").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("AD2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F11").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("AE2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F12").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("AF2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("Eingabe").Select
Range("F13").Select
Selection.Copy
Sheets("Kontrollblatt").Select
Range("AG2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("A2").Select
Selection.End(xlDown).Select
Sheets("Eingabe").Select
Range("B1").Select
Selection.ClearContents
Range("H2").Select
Selection.Copy
Range("F1,F2,F3,F4,F5,F6,F7,F8,F9,F10,F11,F12,F13").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Range("B1").Select
Else:
Exit Sub
End If
End Sub