Thread: Deletion of rows where a value is satisfied
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Larry Wallis[_2_] Larry Wallis[_2_] is offline
external usenet poster
  
Posts: 1
Default Deletion of rows where a value is satisfied
I have a spreadsheet with 3 colums. Columns are headed Part Number,
Description and Qty.

What I would like to do is delete all rows where the qty value is zero.

I can't do this using auto filter as I have some small sub headings within
the list and want them to stay visible.

Any ideas please?

Many thanks.

Larry.
Reply With QuoteReply With Quote