Automatic sorting

Occasional Visitor

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


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.