Today I want to show you how to set up a data drop-down list that is automatically updated when we add new items or options to the list. Dropdown or data validation lists are really useful when you want to control data entry into your Excel workbook. By g

If you click Yes, the new item is added to the drop down list, in alphabetical order. Video: Add New Items to Drop Down. Create a drop down list that allows users to add new items. If you confirm, new items will be automatically added to the drop down lis

Oscar, Thanks for the method to automatically add and sort drop-down list items. I've been trying to resolve one issue, which I can't seem to figure out (ref. your Excel spreadsheet). What I’ve found is that if there’s a name in the first row