title: EXCEL VBA - Creating a dynamic dropdown based on a cell range and a string
body: <p>Ok, so I currently have a dropdown that is populated from a range on a separate sheet.</p>
  
  <p>I want to be able to decrease the values in the dropdown by only adding values that have a text value from another cell within each values text.</p>
  
  <p>for example:
  Cell A1 says 'table'
  Cell A2 is the dropdown that pulls in the values from the range
  The range has 'table','large table','stool'</p>
  
  <p>Currently the dropdown would bring in all of the values. In this instance I would want it to bring just 'table' and 'large table' as they both have 'table' in them.</p>
  
  <p>an example of my file can be found here
  <a href="http://www.filedropper.com/example_1" rel="nofollow">http://www.filedropper.com/example_1</a></p>
  
  <p>Please help.. I'm tearing my hair out!</p>
  
  <p>Thanks
  Mike</p>