Unique Drop Down Lists that Automatically Update with New Values
How to make a data validation drop down list that will always update with a unique list of values from a table or column of data in Excel.
This allows you to generate a list from any table or data set without having to first remove duplicates. You can even sort the values in the list without any extra steps.
Resources
Excel Data Validation (Microsoft)
Question? Ask it in our Excel Forum
Excel VBA Course - From Beginner to Expert
200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Tutorial: Step-by-step instruction on how to make automatically updating dependent data validation ...
Tutorial: Ensure that your Data Validation Drop Down Lists or Menus are automatically updated with ...
Tutorial: How to create UserForm drop-down menus that change based on what was selected in another d...
Tutorial: Quickly make data validation drop down lists (menus) in Excel. This method is simple, onl...
Tutorial: How to use a drop down list (data validation) to create a date in Excel. This technique c...
Tutorial: Multiple columns of data within a UserForm ComboBox drop-down menu in Excel. I'll show you...
Subscribe for Weekly Tutorials
BONUS: subscribe now to download our Top Tutorials Ebook!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)