Ok AMIGOS...
Here is a macro that goes to column "F" finds the the cell that contains
"take out" then deletes the row. The problem is that it takes to long to
run.
So here is what I want to do. I sorted the "F" column to group all the
"take out" cells together, so the macro will start deleting the all rows
first then will reach a point when it will no longer find "Take out" cells
and stop looking.
So now the macro will not have to search the hole list.
Is this Possible...
Keep In Touch
Marco Estrella

Range("F:F").Select

With Selection

Set C = .Find("Take Out", LookIn:=xlValues)
If Not C Is Nothing Then
firstAddress = C.Address
Do
Set d = C.Offset(-1, 0)
C.EntireRow.Delete
Set C = .FindNext(d)

Loop While Not C Is Nothing
End If
End With

I am not so sure but I tink I found this macro in
http://www.cpearson.com/excel.htm Cool stuff there.