title: How to extract all drop down values from a data validated cell in excel to single cells for each value?
body: <p>I have a drop down list in Excel with 500 values in it. How do I get those values into single cells for each value? Basically, 500 values in 500 different cells from where I can use those values without having to search through the entire drop down.</p>
  
  <p>NOTE: I can't use the data validation dialog because the values are referenced from another workbook which I don't have access to</p>