There's a sample Excel workbook on my Contextures website that uses a bit of Excel VBA to automatically add new items to an Excel data validation drop down list.

For example, if the drop down list shows Apple, Banana and Peach, you can type Lemon in the data validation cell. Then, as soon as you [...]