How do I conditionally delete rows based on cell contents?

I would like to delete a whole row based on the contents of a cell that
resides in the same row to be deleted. This would then apply to the whole
spreadsheet, row by row.

Check out www.ASAP-utilities.com ......they have a free add-in that has a
feature that should do what you want.

Vaya con Dios,
Chuck, CABGx3




"John Chan" <John [email protected]> wrote in message
news:[email protected]...
> I would like to delete a whole row based on the contents of a cell that
> resides in the same row to be deleted. This would then apply to the whole
> spreadsheet, row by row.

John

Data>Filter>Autofilter.

Select the column that would have the cell with the content and filter for
that value.

Then F5>Special>Visible cells and OK.

Edit>Delete row.


Gord Dibben Excel MVP



On Mon, 13 Jun 2005 14:16:02 -0700, John Chan <John
[email protected]> wrote:

>I would like to delete a whole row based on the contents of a cell that
>resides in the same row to be deleted. This would then apply to the whole
>spreadsheet, row by row.