Sorting

[S. Kissing]

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

 

[Jim Thomlinson]

Using macros you can do it but generally speaking your end users will find it
very disconcerting. As soon as you hit enter the item you just typed
disappears and in it's place you see the last alpha entry... You spend a lot
of time wondering if you typed it correctly and just where it really went.

Generally speaking you are better off to add a command button to sort the
list or use events such as activating and deactivating the sheet.

 

[Gord Dibben]

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
Data>Sort.

If you want auto-sort, post back.


Gord Dibben MS Excel MVP