Sep 28 2022 08:41 PM
Can I get excel to auto sort cells as new information is added?
Sep 29 2022 01:17 AM
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.