title: How to hide columns in excel with no values in a filter list?
body: <p>I have a large spreadsheet of various chemicals and their specifications; however, not every chemical requires a value in each column so there are a lot of blank cells. I'm wondering if there's something I can do to hide a column if there are no values in it when I select it from a drop-down list filter?</p>
  
  <p>For example, I click on the drop-down list and select "potassium hydroxide" and I want it to hide the columns "Moisture" because there are no values in it.</p>
  
  <p>what it looks like now:</p>
  
  <p><a href="https://i.stack.imgur.com/Dljt2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Dljt2.png" alt="enter image description here"></a></p>
  
  <p>I tried using some VBA code earlier but I don't seem to get how to incorporate it into the drop-down list filter. </p>