Hi!

Why not just sort after the numbers have been entered?

Using formulas and a helper column:

Assume numbers are entered in column A

Enter this formula in column B:

=IF(COUNT(A:A)=ROWS($1:1),SMALL(A:A,ROWS($1:1))," ")

Copy down. If you expect to enter 10 numbers in column A then copy this
formula down 10 rows.

Biff

"Longtime" wrote in message
...
Is there a way to automatically sort a column in ascending order while
entering numbers so that the column is sorted when last number is entered.
Appreciate all help.