AW: Daten filtern
09.11.2006 23:00:35
ramses
Hallo
den Code in das Klassenmodul "Diese Arbeitsmappe" kopieren
Option Explicit
Private Sub Workbook_Open()
Dim i As Long
Dim srcSheet As Worksheet
Dim tarSheet1 As Worksheet, tarSheet2 As Worksheet, tarSheet3 As Worksheet
Set srcSheet = Worksheets("Tabelle_mit_SQL-Daten")
Set tarSheet1 = Worksheets("Tabelle_mit_FAX-Daten")
Set tarSheet2 = Worksheets("Tabelle_mit_Monitor-Daten")
Set tarSheet3 = Worksheets("Tabelle_mit_sonstigen-Daten")
'FAX Daten kopieren
tarSheet1.Cells.Clear
With srcSheet
.Rows(1).Copy tarSheet1.Rows(1)
For i = 2 To .Cells(.Rows.Count, 1)
If .Cells(i, 11) = "FAX" Then '11 = K
.Rows(i).Copy tarSheet1.Rows(tarSheet1.Cells(Rows.Count, 1).End(xlUp).Row + 1)
End If
Next i
End With
'Monitordaten kopieren
tarSheet2.Cells.Clear
With srcSheet
.Rows(1).Copy tarSheet2.Rows(1)
For i = 2 To .Cells(.Rows.Count, 1)
If .Cells(i, 12) = "Monitor" Then '12 = L
.Rows(i).Copy tarSheet2.Rows(tarSheet1.Cells(Rows.Count, 1).End(xlUp).Row + 1)
End If
Next i
End With
'Sonstige Daten kopieren
tarSheet3.Cells.Clear
With srcSheet
.Rows(1).Copy tarSheet3.Rows(1)
For i = 2 To .Cells(.Rows.Count, 1)
If .Cells(i, 12) = "Monitor" Then '12 = L
.Rows(i).Copy tarSheet3.Rows(tarSheet1.Cells(Rows.Count, 1).End(xlUp).Row + 1)
End If
Next i
End With
'Bei weiteren Daten
'einfach genauso wie oben weitermachen
'Variablen zurücksetzen
Set srcSheet = Nothing
Set tarSheet1 = Nothing
Set tarSheet2 = Nothing
Set tarSheet3 = Nothing
End Sub
Sollte eigentlich funktionieren
Gruss Rainer