You would have to insert a worksheet_change event into the sheet itself
to watch for changes in the key row, but that might get weird since it
would sort as soon as you entered that cell's data, and you'd find the
row you were editing now in the middle of the data set.

Perhaps a less irritating solution would be to record a macro of you
sorting the data and put it on a button on your sheet, you can press it
to quickly sort the new data when you're DONE entering it.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61755