View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christine
 
Posts: n/a
Default Can I delete an entire row if condition is not met?

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.