The easiest way is to add autofilter to that column,
DataFilterAutofilter..., and then when you click the dropdown, you see all
the values, and if you select one, only those rows matching are then
visible, so you can select them all (F5Special, click Visible Cells Only),
and then delete the, (Ctrl & -, and tick Entire row).

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Christine" wrote in message
...
I'm working on Outlook 2003 and Word 2000 which are not compatible. I have
an
Excel Sheet which are my contacts from Outlook and I want to re-work it to
have only a certain category left.

I need a macro that does
- search a certain column
- deletes the row if it does NOT find a certain condition

Ideal would be a little pop up window to enter which category I want left.

I can't figure it out. Can anybody help? Thanks.