alphabetical order for a list

[Guest]

using the validation function to make a drop down list, I will be entering
items in the list as time passes. Therefore I will need to have it
automatically put my list in alphabetical order. How can I to this.

Thank you,
Brian

 

[Debra Dalgleish]

There's a sample file here that adds new items to the data validation
list, and sorts them:

http://www.contextures.com/excelfiles.html

Under the heading 'Data Validation', look for 'Update Validation List'.