Delete ROW based on Cell Contents
 

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

Delete ROW based on Cell Contents
 

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

Jim Thomlinson


"HeatherJ" wrote:

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

Delete ROW based on Cell Contents
 

Filter sounds good--how would I do that?

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"HeatherJ" wrote:

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

Delete ROW based on Cell Contents
 

Data | Filter | Auto Filter

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

Jim Thomlinson


"HeatherJ" wrote:

Filter sounds good--how would I do that?

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"HeatherJ" wrote:

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

Delete ROW based on Cell Contents
 

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

"Jim Thomlinson" wrote:

Data | Filter | Auto Filter

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

Jim Thomlinson


"HeatherJ" wrote:

Filter sounds good--how would I do that?

"Jim Thomlinson" wrote:

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

Jim Thomlinson


"HeatherJ" wrote:

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