Delete ROW based on Cell Contents

[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

 

[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.

 

[HeatherJ]

Filter sounds good--how would I do that?

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.

 

[Jim Thomlinson]

Data | Filter | Auto Filter

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

 

[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