title: How do I hide all columns except for ones that contain a certain specific value/text?
body: <p>What's a VBA macro I can use to filter out the columns that don't contain a certain string of text/value. In the example below, I start off with data that has some columns I don't want to see. I want to hide all columns except for ones containing at least one cell that has value I want to see, in this example, it's the "Good" data. </p>
  
  <p>Starting with this:</p>
  
  <p><a href="https://i.stack.imgur.com/YeJoU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YeJoU.png" alt="Excel spreadsheet image showing four columns containing either cells with either &quot;Bad&quot; or &quot;Good&quot; with one column having only &quot;Bad&quot;"></a></p>
  
  <p>Ending with this:</p>
  
  <p><a href="https://i.stack.imgur.com/Msbei.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Msbei.png" alt="Excel spreadsheet image showing three columns containing cells with both &quot;Bad&quot; or &quot;Good&quot;"></a></p>