Forum Discussion
ianjune
Apr 23, 2021Copper Contributor
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
1 Reply
Sort By
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.