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