Hi Guys, in the attached workbook on worksheet "Attendance All-Time" I have an update button that sorts by Column Q (Descending) and then by Column A (Ascending). It works perfectly.
I've copied this VBA on to worksheet "Prize Winners" and have edited the code to sort by Column Q (Descending) and Column R (Ascending) but it doesn't work.
I'm new to this to it's probably something very simple I've overlooked.
Many thanks.
Last edited by Marvo; 03-26-2024 at 10:49 AM.
What is in error? It looks OK to me.
Last edited by JohnTopley; 03-26-2024 at 10:34 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Column R sorts out the names alphabetically. (Surname)
Yes sorry, John, it is working now. Seems to be a bit temperamental, sometimes doesn't work first time you click the button. Never mind, its reassuring managed to set it up right. Thank you.
Column R returns a ID number based on Name.
Sorting R makes no sense: All you want is that the sort on Q results and the whole table being correct and hence R will be correct.
John MARVESLEY is ID 91 and the leader based on winnings.
John Marvesley is the 91st person alphabetically. I was looking for a way of sorting two people when they have the same total, alphabetically seemed to be the way to go. Can't sort the names Alphabetically in column B as it will do it from first name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks