Sub
Tabelle_075_dbl()
If
Not
WorksheetExists(
"0,75 dbl"
)
Then
Worksheets(
"Vorlage"
).Copy Before:=Worksheets(1)
Set
Worksheet = Worksheets(1)
Worksheet.Name =
"0,75 dbl"
Else
MsgBox
"Tabelle 0,75 dbl existiert bereits"
, 48
Exit
Sub
End
If
Sheets(
"0,75 dbl"
).Range(
"A1"
).Value =
"0,75_dbl_Lapp"
With
Sheets(
"Drahtsatz kopieren"
)
.Range(
"$A$2:$M$200"
).AutoFilter Field:=4, Criteria1:=
"DBU"
.Range(
"$A$2:$M$200"
).AutoFilter Field:=5, Criteria1:=
"0,75"
.Range(
"F:F"
).Copy Sheets(
"0,75 dbl"
).Range(
"C8"
)
.Range(
"I:I"
).Copy Sheets(
"0,75 dbl"
).Range(
"M8"
)
.Range(
"J:J"
).Copy Sheets(
"0,75 dbl"
).Range(
"S8"
)
Sheets(
"0,75 dbl"
).Range(
"8:8,9:9"
).Delete
Sheets(
"0,75 dbl"
).Range(
"A1"
).
Select
If
.AutoFilterMode
Then
If
.FilterMode
Then
.ShowAllData
.
Select
Range(
"A1"
).
Select
End
With
MsgBox
"Tabelle 0,75 dbl wurde erstellt"
, 64
End
Sub