Dropdown list always shows unique values from a column based on lookup value

Name a cell on Sheet2 "IDs" located where a list of unique IDs can be stored - make sure that there is room for the list below that cell.

Then copy this code, right-click the sheet tab of "Sheet2" and select "View Code", and paste the code into the window that appears. Then save the workbook as a macro-enabled .xlsm. The code will create a list of unique ID values in the named range IDs - then you can use Data Validation / list option, setting the source to =IDs and the dropdown on those cells will have the updated list, which will be created any time you activate Sheet2.

Please Login or Register  to view this content.