Sorting Problem

[RonLEngle]

Hey all, Wondering if someone can look at my spreadsheet and help me out..What i have here is an exam spreadsheet that keeps track of exam scores, overall scores, and lets me know total points available and points left so i know when people are mathematically eliminated.



What i want to do is create a Macro button on far right that automatically sorts the Sheet to far right (Name, Exam Score, and Overall score) by Overall score and copy that button to each of the 18 total exams. Ive attached SpreadsheetSPA Scoring Sheet Blank.xlsm

Would appreciate help with this or info on how i can do this, Thanks

Ron