Sorting Rows/Columns Automatically

[BG]

I have a spreadsheet and I want to automatically sort the rows and columns as
new data is entered into blank cells. What is the best way to do this?

 

[JBeaucaire]

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

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