Delete ROW based on Cell Contents

H

HeatherJ

Is there a way to automatically delete a row based on a cell content within
that row. Example: Delete row 24 if B24 < 3. I need to apply this to an
entire worksheet.

Thanks, Heather
 
J

Jim Thomlinson

The only way to do that is to use a macro. Be very careful with this approach
as their is no undo and once deleted the row is permanently gone with no way
to get it back.

My preference for this type of thing is to use a filter. The original data
is still their but it is filtered out by your criteria. Let us know which way
you want to go.
 
H

HeatherJ

Filter sounds good--how would I do that?

Jim Thomlinson said:
The only way to do that is to use a macro. Be very careful with this approach
as their is no undo and once deleted the row is permanently gone with no way
to get it back.

My preference for this type of thing is to use a filter. The original data
is still their but it is filtered out by your criteria. Let us know which way
you want to go.
 
J

Jim Thomlinson

Data | Filter | Auto Filter

heading become drop downs. You will probably want Custom where you can
specify > 3
 
H

HeatherJ

This worked great, thanks! Would you mind also telling me how to permanently
delete rows using a macro. I have used macros before and am familiar with
them, but am not sure how to do this specifically.

Thanks again, Heather
 

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

Top