Deleting Rows w/ Specific Criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to delete rows automatically with specific criteria? Say I
want to automatically delete all rows that have a value of 0 in row c. Thanks!
 
I like to use this:

Select column C
Data|Filter|autofilter
Filter to show the 0's
delete the visible rows
data|filter|autofilter to remove that filter.
 
Back
Top