Makro kürzen
18.04.2006 11:36:26
Wolfgang
Ich habe ein Makro aufgezeichnet um Daten aus bestimmten Zellen aus einem Datenblatt in die erste freie Zeile in eine Datenbankblatt zu copieren und dann neu zu sortieren.
Nun ist das Makro recht groß geworden.
Meine Frage ist lässt sich das Makro kürzen, wenn ja wie?
Gruß Wolfgang
Anbei das besagte Makro:
Sub Datenblatt_Werte_nach_DATA_Schreiben()
If MsgBox("Soll der Inhalt des Datenblattes in die Datenbank eingegeben werden ?" _
& Chr(13) & "Die Daten werden in der Datenbank automatisch nach Alphabet einsortiert!", vbQuestion + vbYesNo, "Inhalt des Datenblattes nach DATA Einfügen und Sortieren") = vbYes Then
Application.ScreenUpdating = False
Sheets("Datenblatt").Select
Range("C1").Select 'Firma
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("L1").Select 'Stand
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 2).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C2").Select 'Strasse
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 3).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("F2").Select 'PLZ
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 4).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("H2").Select 'Hamburg
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 5).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("L2").Select 'Telefon
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 6).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C3").Select 'Branch/Artikel
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 7).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("H3").Select 'Art / Ort
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 8).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C6").Select 'Eigentümer Name
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 9).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E6").Select 'Anschrift
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 10).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("H6").Select 'Tel Firma
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 11).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("J6").Select 'Tel.Privat
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 12).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("L6").Select 'Handy
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 13).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("B1").Select 'Zeile14 ObjektNr!!
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 14).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C7").Select 'Verwalter
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 15).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E7").Select 'Anschrift
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 16).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("H7").Select 'Telefon Firma
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 17).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("J7").Select 'Telefon Privat
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 18).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("L7").Select ' Handy
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 19).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C8").Select 'Hausmeister1
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 20).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E8").Select 'Anschrift
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 21).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("H8").Select 'Telefon Firma
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 22).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("J8").Select 'Telefon Priv.
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 23).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("L8").Select 'Handy
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 24).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C9").Select 'Hausmeister2
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 25).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E9").Select 'Anschrift
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 26).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("H9").Select 'Telefon Firma
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 27).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("J9").Select 'Telefon Privat
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 28).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("L9").Select 'Handy
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 29).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C10").Select 'Sicherheitsdienst
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 30).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E10").Select 'Anschrift
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 31).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("H10").Select 'Telefon Firma
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 32).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("J10").Select 'Felefon Priv.
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 33).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("L10").Select 'Handy
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 34).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("B1").Select 'Zeile35 ObjektNr!
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 35).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C12").Select 'Info Anfahrt
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 36).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C14").Select 'ASK
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 37).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C15").Select 'Zeile3
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 38).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C16").Select 'Zeile4
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 39).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C17").Select 'Zeile5
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 40).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C18").Select 'Zeile6
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 41).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C19").Select 'Zeile7
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 42).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C20").Select 'Zeile8
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 43).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C21").Select 'Zeile9
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 44).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C22").Select 'Zeile10
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 45).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select 'Zeile11?!!?
Range("C23").Select 'Besondere Risiken1
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 47).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C24").Select 'Besondere Risiken2
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 48).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C25").Select 'Besondere Risiken3
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 49).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C26").Select 'Besondere Risiken4
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 50).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("A30").Select 'Anzahl
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 51).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C30").Select 'Lageplan1
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 52).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C31").Select 'Lageplan2
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 53).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("C31").Select 'Lageplan3
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 54).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("B1").Select 'Zeile 55 ObjektNr!!
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 55).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E30").Select 'Zugstadorte1
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 56).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E31").Select 'Zugstandorte2
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 57).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("E32").Select 'Zugstandorte3
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 58).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("G30").Select 'FF1
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 59).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("G31").Select 'FF2
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 60).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("G32").Select 'FF3
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 61).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("I30").Select 'FF4
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 62).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("I31").Select 'FF5
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 63).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("I32").Select 'FF6
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 64).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("K30").Select 'Löschzugfolge1
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 65).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("K31").Select 'Löschzugfolge2
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 66).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("K32").Select 'Löschzugfolge3
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 67).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("M30").Select 'Löschzugfolge4
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 68).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("M31").Select 'Löschzugfolge5
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 69).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("M32").Select 'Löschzugfolge6
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 70).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("N1").Select 'Letzter Bearbeiter
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 71).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Datenblatt").Select
Range("B1").Select 'ObjektNr
Selection.Copy
Sheets("DATA").Select
ActiveSheet.Cells(65536, 1).End(xlUp).Offset(-1 * Not IsEmpty(Cells(1, 1)), 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Call Sortieren_nach_Firma_Aufwärts
Application.ScreenUpdating = True
End If
End Sub