Automatic sorting

[ianjune]

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

[#2]

@ianjune 

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.