I have a spreadsheet where I add names in column one, I then add other detail in column two etc. My problem is that I would like to transfer the names, from column one only, to another free column then sort these names into alphabetical order. At the moment I copy and paste the names from one to a free column the highlight the cells then right click and sort. It works but is it possible to automate this process so when I enter the name in column one it will automatically sort itself into alphabetical order in another column.
In brief, can I sort names in a column so that when I add a name, it automatically moves into alphabetical order. Thanks…..:thumb:
In brief, can I sort names in a column so that when I add a name, it automatically moves into alphabetical order. Thanks…..:thumb: