Creating a dropdown list from values in a column on another sheet
I am trying to create a simple dropdown list of values to select from a customized list of values in another sheet. This list will change over time, so I want to use this reference sheet to update the list values. I have setup the list in Sheet Reference Manager and there is only one column of data in the reference sheet which contains the values for the dropdown list. However, I am at a loss as to what formula to use on the primary sheet column so that it is using the values from the referenced sheet. Thank you for assisting.