Makro
07.07.2005 16:47:57
dmoser
Sub wech2()
ende = Cells(Rows.Count, 7).End(xlUp).Row
For i = ende To 2 Step -1
If Cells(i, 7) = "Telefax" Then
Rows(i).Copy
Sheets("Tabelle2").Select
Rows(i & ":" & i).Select
Sheets("Tabelle1").Select
End If
Next i
End Sub