#1
|
|||
|
|||
Sorting Problem
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 |
#2
|
||||
|
||||
Hi
posting in the correct forum increases your chances on a quick answer. I moved it to the programming forum for you
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Have a look and give this a try.
I deleted two columns from Sheet "Exam 1" to make it the same as the other sheets. Uses column "V" as a helper column for Un-Sorting the table back to its original. This column is hidden when populated. Let me know how it goes. |
#4
|
|||
|
|||
About the buttons not on all sheets....
Remove the Exit For line in the Insert_CommandButtons sub. |
#5
|
|||
|
|||
Revision.
Uses helper column to maintain formulas in table when sorted. |
#6
|
|||
|
|||
Really appreciate your help wit my spreadsheet, is there anyway you can add up to maximum of 35 students to both scoring entry on left and sort sheet on right. Ive tried and can add to helper row and copy and paste formulas but when i went to sort it wouldnt sort the added students
|
#7
|
|||
|
|||
In
Private Sub Add_Helper_Column() Private Sub Exam_Sort_OverAll() Private Sub Exam_UnSort() change the bottom of the ranges from 36 to 40 |
#8
|
|||
|
|||
awesome that worked, thanks you very much for your help
|
#9
|
|||
|
|||
You're welcome.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sorting problem in Excel | nrsmd | Excel | 2 | 10-08-2017 11:54 AM |
Sorting Charts - series custom color problem | Rhene | Excel | 0 | 08-02-2017 11:20 AM |
Problem sorting names alphabetically? | mikehende | Excel | 12 | 09-12-2012 12:00 PM |
sorting problem | gsrikanth | Excel | 4 | 02-16-2012 12:30 AM |