Want to delete every worksheet that *doesn't* contain one of several phrases

Hi all,

I've got a problem that I've had trouble finding a solution for using Google-Fu.

In short, I want to have a macro or otherwise automatable solution that deletes a worksheet if it doesn't contain either Phrase A, Phrase B, Phrase C, or Phrase D. (any of the four phrases will do.)

Can VBA do this?

Since I use a lot of ASAP Utilities and AutoHotKey, I can automate the 'outer shell' pretty easily if I can figure out the most basic step: How do I have Excel check whether or not a cell contains a given line of text?

Ideally, this would simply be an '=IF' statement. But I can't seem to put one together that answers this.


Or could I filter sheets based on whether or not they have one of the phrases, and then copy only the sheets still displayed?


Not sure how to go about handling this.

Televangelist,

Welcome to the Excel Forum.


To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed/changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, click on the New Post button, then scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

Please Login or Register  to view this content.

I'm only posting this because I've been working on this for a little while. Also, I couldn't finesse it quite like snb's so I changed the Phrase A to Phrase1 and so on.

Please Login or Register  to view this content.