Hello
I have attached the sheet i am working on -
I am looking to -
Transfer the names automatically off of the Registration sheet onto the A-Z sheet and then sort by surname and then first name
But when any new names are added onto the Registration sheet from row 81 onwards - they are automatically added into the list on the A-Z sheet in the correct place.
These sorted names will then go onto the Matrix sheet - across row 1 and down column A (highlighted in yellow) -
Also any new names added to the registration sheet will automatically go into these Matrix sheet lists.
Sorry if this isnt very clear as i am unsure about how to describe it - hopefully someone is able to assist
Thank you
Bookmarks