Does anyone know of a formula you can use to sort a list of text
alphabetically?

I know the data/sort option but I want something that can pick up new
entries in the original data list without the use having to intervene.

Seems like a straightforward enough idea but I can't find anything.


--
paddyyates
------------------------------------------------------------------------
paddyyates's Profile: http://www.excelforum.com/member.php...o&userid=29744
View this thread: http://www.excelforum.com/showthread...hreadid=494589