title: Excel or VBA - populate a drop down list from a dynamic column in another sheet with no duplicates
body: <p>I don't know if this is even possible, but I am trying to do a couple of things that require me to populate drop down lists, and a normal cell by cell list, based on the items in a column on another sheet. I know how to do this with a regular column, but the column I want to use changes length and has many duplicate values in it, as it is an inventory of sorts. </p>
  
  <p>So on this sheet, in C5, </p>
  
  <p><a href="https://i.stack.imgur.com/arEMH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/arEMH.png" alt="enter image description here"></a>
  that value should be able to be selected from a drop down list based on the contents of column B in the second sheet, but also without having to scroll through duplicates. 
   <a href="https://i.stack.imgur.com/8HR7J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8HR7J.png" alt="enter image description here"></a></p>
  
  <p>I am happy to use either VBA or general excel formulas to achieve this. I am also aware that I don't think I have explained this very well so please feel free to prompt me for more information as required. </p>