Forum Discussion
Automatic sorting
I am a volunteer at a hospital and am designing a lost property register. My question is Can I format register to automatically sort into alphabetical order as new items are entered and if so how
Sorting a list while you are entering data would be very confusing - a row would jump to another location when you edit it.
As an alternative, you could write VBA code to sort the list when you open the workbook and/or when you activate the sheet the list is on.