Auto Sort

Occasional Visitor

Can I get excel to auto sort cells as new information is added? 

1 Reply


That would require VBA code, but I wouldn't recommend sorting data as they are entered. It would cause a row to potentially move out of sight the moment the user edits a cell in that row.

Instead, I would sort the data when the workbook is opened and when the user activates the sheet with the data.

I have attached a small sample workbook. There is code in Module1, in ThisWorkbook and in the code module of Sheet1. You'll have to allow macros when you open the workbook.