I have an Excel file with data in Column A. My attached file has data from A2:A6. I want to create a drop down list on Cell B2 of Sheet2. I would like to create a list that will be populated with the data in the Used Range in Sheet1's Column A i.e. if this column has additional data in the future it should change dynamically.
I tried to apply a Formula for my Validation Object I found on the following website but it does not work.
Excel Data Validation -- Dependent Lists With INDEX (contextures.com)
Is it possible to create such a drop down list with a Formula?