title: Auto-hiding columns based on cell criteria in another worksheet
body: <p>I am new to VBA coding and have so far successfully managed to create a scoping sheet in a workbook which hides/unhides tabs based on workbooks users' responses to yes/no questions.</p>
  
  <p>I need to further refine the workbook so that the yes/no responses provided in the scoping tab lead to the <strong>auto</strong> hiding of columns in other sheets. Using a previous thread on this website I used this code (obviously amended for my own cells refs) on one of the tabs:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
      If Target.Address = "$B$6" Then
          Select Case Target.Value
          Case Is = "Cast"
              Columns("f").EntireColumn.Hidden = False
              Columns("d").EntireColumn.Hidden = True
              Columns("e").EntireColumn.Hidden = True
          Case Is = "LDF"
              Columns("f").EntireColumn.Hidden = True
              Columns("d").EntireColumn.Hidden = False
              Columns("e").EntireColumn.Hidden = False
          Case Is = "Select ROV Type"
              Columns("f").EntireColumn.Hidden = False
              Columns("d").EntireColumn.Hidden = False
              Columns("e").EntireColumn.Hidden = False
          End Select
  </code></pre>
  
  <p>In B6, I have a formula (=Name) which pulls through from the scoping tab. While the above code works, it only does so where I manually enter the cell to re-pull through data... any hints on:
  - linking through to the original scoping tab in my macro, bypassing the cell reference; and 
  - automating the column hides?</p>