ニュース

Excel populates the dropdown with the list of animals. If you modify the list of animals on the List sheet, the dropdown will automatically update accordingly. Try that now.
Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.