title: Use VBA macros to create a selection menu for filtering columns
body: <p>I have an Excel sheet that looks like this.</p>
  <p><a href="https://i.stack.imgur.com/7PKn8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7PKn8.png" alt="Selection Menu" /></a></p>
  <p>What I would like to do is is use the selections in these two group boxes to filter columns in two other sheets (titled &quot;Units&quot; and &quot;Cash&quot;). I created macros for each radio button. Here is what they look like:</p>
  <pre><code>Sub ProdLineAll()
  '
  ' ProdLineAll Macro
  '
  
  With Worksheets(&quot;Units&quot;)
      .Range(&quot;$C:$C&quot;).AutoFilter field:=1, Criteria1:=&quot;ALL&quot;, VisibleDropDown:=False
  End With
  
  With Worksheets(&quot;Cash&quot;)
      .Range(&quot;$C:$C&quot;).AutoFilter field:=1, Criteria1:=&quot;ALL&quot;, VisibleDropDown:=False
  End With
  
  End Sub
  </code></pre>
  <p>This would work fine except that it clears all other filters, so by running the '''ProdLineAll()''' macro I'm also unfiltering the Same Store Sales filter.</p>
  <p>My next thought was to use a button to somehow apply all the filtering at once, but I'm not sure how I can use this button to check which radio buttons are selected in each group box.</p>
  <p>How can I dynamically filter multiple columns based on the above selection criteria?</p>