Unique Drop Down Lists that Automatically Update with New Values

Download the File: https://www.teachexcel.com/excel-tuto...

Full Excel VBA/Macro Course [On Sale!]: https://www.teachexcel.com/vba-course...

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.

I hope you enjoy this Excel tutorial!

Resources:
TeachExcel Online Courses: https://www.teachexcel.com/premium-co...
Excel Data Validation (Microsoft): https://support.microsoft.com/en-us/o...

#msexcel #tutorial #exceltips #freetutorial #exceltips #excel