Forum Discussion
Automatic sorting
Hello David_Cox1201 ,
How automatic do you need this to be? If your data is in an Excel Table, then you can sort by the table headers. Everything else will require programming.
If you need this to happen automatically, then you can start the macro recorder, then sort the data, then stop the macro recorder. After that you can configure Excel to run the macro whenever the data changes. This can be done with a Worksheet_Change event.
https://docs.microsoft.com/en-us/office/vba/api/excel.worksheet.change
IngeborgHawighorst Thank you! I've recorded the macro. I'm a novice here, so pardon my ignorance...but I can't figure out how to configure Excel to run it when the data changes. I clicked the link, but where do I set up the Worksheet Change Event?