If, then macro deletes contents in another column

Posted by Elle on February 04, 2002 8:29 AM

I want to create a macro where one column has an if, then function. When the function is false, I want the contents in another column to be deleted.

Is this possible, and can I do this without VB? (I know nothing about VB)

any advice, tips would be greatly appreciated.

thanks.

Posted by Damon Ostrander on February 04, 2002 1:24 PM

Hi Elle,

This is easy to do without the necessity of a macro (although such a macro would only require a few lines of code). Simply add an autofilter to the true/false column (Data -> Filter -> Autofilter). Then use the autofilter dropdown to display only the rows with FALSE values. Then select the entire column containing the values you want to delete and hit the delete key. Then set the filter back to All to see the results.

Happy computing.

Damon