title: Is it possible to apply a filter to a data validation drop down list?
body: <p>I have a drop down list on a that shows a consolidated parts library from another worksheet. This worksheet is constantly going to be updated until we can get a working database so the way the parts list functions is more or less set in stone.</p>
  
  <p>The parts library is bought over using a query and looks like this:
  <a href="https://i.stack.imgur.com/oL6w1.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oL6w1.jpg" alt="enter image description here"></a></p>
  
  <p>I have concatenated some of the data to form a named table `ProjectTab and looks like this:
  <a href="https://i.stack.imgur.com/dop1Z.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dop1Z.jpg" alt="enter image description here"></a></p>
  
  <p>The named table forms a detailed data validation list which looks like this:
  <a href="https://i.stack.imgur.com/tpwtl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tpwtl.jpg" alt="enter image description here"></a></p>
  
  <p>In order for the worksheet to auto-fill I shortened the output of the data validation list to only output the <code>Part Index</code> which looks like this:</p>
  
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  
  On Error Resume Next
  
  Dim textVal As String
  Dim strVal As String
  
      strVal = Target.Value
          If Target.Column = 2 Then
              textVal = Left(strVal, 9)
                  Target.Value = textVal
  
      End If
  End Sub
  </code></pre>
  
  <p>The following <code>IF</code> statement allows me to figure out what Type of product the part is
  <code>=IF(B2&gt;0,IF(LEFT(D2,1)="1","Assembly",IF(LEFT(D2,1)="2","Sub-Assembly",IF(LEFT(D2,1)="3","Software",IF(LEFT(D2,1)="4","Hardware",IF(LEFT(D2,1)="5","Chemical",IF(LEFT(D2,1)="6","Spare",IF(LEFT(D2,1)="7","Spare",IF(LEFT(D2,1)="8","Document",IF(LEFT(D2,1)="9","Misc",""))))))))),"")</code>
  Which produces the following column:
  <a href="https://i.stack.imgur.com/0SEnn.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0SEnn.jpg" alt="enter image description here"></a></p>
  
  <p>I would like to use something similar to the above <code>IF</code> statement to filter the drop down list to select the parts i.e. I preselect the <code>Assembly Type</code> via a filter at the top of the work sheet which in-turn filters the <code>Part List</code> drop down list to the respective type.</p>
  
  <p>Is this possible? If so how could I go about doing this?</p>
  
  <p>Thanks,</p>
  
  <p>Dan</p>