I do not recommend auto-sorting upon entry.

Once your list gets longer, it is very difficult to find and fix any data
entry mistakes.

I like to confirm first that correct data has been entered then do the sort.


Gord Dibben MS Excel MVP

On Mon, 7 Dec 2009 23:21:01 -0800, Fareez
wrote:

Dear All
I have sorted (ascending order)following numbers.
1
2
4
5
if i enter 3 below 5, is there any way to bring automatically 3 below 2
(ascending order)
thanks