Delete Row

[computerman29651]

I need a formula that will look for a certain word, and if that word is found, then delete the row.

For Example:

Column F
Read (test)
Write
Talk (test)
Run
Walk (test)

So, what I need is a formula that if (test) is found, then delete the entire row.

If any additional information is needed, please let me know.

 

[AnotherHiggins]

A formula does not make changes to the worksheet. It returns a value.

You could write a formula, autofilter on the results of that column and delete all rows where the value = "True". But that's a manual process.

If you want this to be done automatically, you will need to use a macro. If you want to pursue a macro solution, please post a new thread in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

...or you could Autofilter and use the CONTAINS criteria and then select and delete in one swell foop! ;-)

Skip,

_[red][/red]