I would like to set an array to 'auto sort' for new inputs

[NA5KAR]

Good Evening,

I've built a fairly large and complex workbook and I will be occasionally adding names into an array in one of the worksheets. Is it possible to set that array to auto sort alphabetically 'A to Z' vertically by simply adding the name to one cell within the array?

Thank you in advance for any guidance.

[teylyn]

Add this code to the sheet module. Change the column to the column you want to sort. The code assumes you have a header in row 1

Please Login or Register  to view this content.

[NA5KAR]

Thank you.