You want your column to sort automatically as you enter new data?

This can be done with sheet event code but I don't think it is a good idea.

Can be very hard to find the last data entered if user makes a mistake in
data entry.

Did user enter llama or plama and where did it sort to?

I suggest just entering the data, check for errors and when happy, just hit
DataSort.

If you want auto-sort, post back.


Gord Dibben MS Excel MVP

On Wed, 17 Sep 2008 12:40:01 -0700, S. Kissing
wrote:

Can I set-up a column so that new data sorts into the list alphabetically?