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 mean column C. I want to delete all rows with a value of 0 in column 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows based on multiple criteria 6
Deleting/removing unused rows in a worksheet 3
Deleting rows meeting certain criteria in a particular column 1
Code problem 4
How to delete rows in visual basic 3
Help With Formula Please 4
Word VBA for deleting Selected Row 0
Delete rows using a macro 2

Back
Top