Hallo,
vergess dir AW 9, hiermit versuch es mal :
###
Private Sub CommandButton1_Click()
lz = Sheets(Datenausgabe).Range("A65536").End(xlUp).Row + 1
Sheets(Datenausgabe).Cells(lz, 1) = Sheets(Formular).Cells(4, 2)
Sheets(Datenausgabe).Cells(lz, 2) = Sheets(Formular).Cells(9, 3)
Sheets(Datenausgabe).Cells(lz, 3) = Sheets(Formular).Cells(9, 7)
Sheets(Datenausgabe).Cells(lz, 4) = Sheets(Formular).Cells(15, 3)
Sheets(Datenausgabe).Cells(lz, 5) = Sheets(Formular).Cells(15, 8)
Sheets(Datenausgabe).Cells(lz, 6) = Sheets(Formular).Cells(18, 3)
Sheets(Datenausgabe).Cells(lz, 7) = Sheets(Formular).Cells(18, 8)
Sheets(Datenausgabe).Cells(lz, 8) = Sheets(Formular).Cells(21, 3)
Sheets(Datenausgabe).Cells(lz, 9) = Sheets(Formular).Cells(27, 3)
Sheets(Datenausgabe).Cells(lz, 10) = Sheets(Formular).Cells(33, 3)
Sheets(Datenausgabe).Cells(lz, 11) = Sheets(Formular).Cells(39, 3)
Sheets(Datenausgabe).Cells(lz, 12) = Sheets(Formular).Cells(39, 8)
Sheets(Datenausgabe).Cells(lz, 13) = Sheets(Formular).Cells(42, 3)
Sheets(Datenausgabe).Cells(lz, 14) = Sheets(Formular).Cells(42, 4)
Sheets(Datenausgabe).Cells(lz, 15) = Sheets(Formular).Cells(42, 5)
Sheets(Datenausgabe).Cells(lz, 16) = Sheets(Formular).Cells(42, 6)
Sheets(Datenausgabe).Cells(lz, 17) = Sheets(Formular).Cells(42, 7)
Sheets(Datenausgabe).Cells(lz, 18) = Sheets(Formular).Cells(42, 8)
Sheets(Datenausgabe).Cells(lz, 19) = Sheets(Formular).Cells(42, 9)
Sheets(Datenausgabe).Cells(lz, 20) = Sheets(Formular).Cells(42, 10)
Sheets(Datenausgabe).Cells(lz, 21) = Sheets(Formular).Cells(42, 11)
Sheets(Datenausgabe).Cells(lz, 22) = Sheets(Formular).Cells(42, 12)
Sheets(Datenausgabe).Cells(lz, 23) = Sheets(Formular).Cells(47, 7)
Sheets(Datenausgabe).Cells(lz, 24) = Sheets(Formular).Cells(50, 3)
Sheets(Datenausgabe).Cells(lz, 25) = Sheets(Formular).Cells(55, 6)
Sheets(Datenausgabe).Cells(lz, 26) = Sheets(Formular).Cells(55, 7)
Sheets(Datenausgabe).Cells(lz, 27) = Sheets(Formular).Cells(55, 8)
End Sub
###
Gruß
Helmut