Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-29-2017, 02:59 PM
RonLEngle RonLEngle is offline Sorting Problem Windows 7 32bit Sorting Problem Office 2010 32bit
Novice
Sorting Problem
 
Join Date: Jun 2017
Posts: 8
RonLEngle is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-30-2017, 01:21 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Sorting Problem Windows 7 64bit Sorting Problem Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 11-30-2017, 11:14 AM
NoSparks NoSparks is offline Sorting Problem Windows 7 64bit Sorting Problem Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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.
Attached Files
File Type: xlsm SPA Scoring Sheet Blank_v2.xlsm (212.9 KB, 10 views)
Reply With Quote
  #4  
Old 11-30-2017, 11:37 AM
NoSparks NoSparks is offline Sorting Problem Windows 7 64bit Sorting Problem Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

About the buttons not on all sheets....
Remove the Exit For line in the Insert_CommandButtons sub.
Reply With Quote
  #5  
Old 12-02-2017, 08:56 AM
NoSparks NoSparks is offline Sorting Problem Windows 7 64bit Sorting Problem Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

Revision.
Uses helper column to maintain formulas in table when sorted.
Attached Files
File Type: xlsm SPA Scoring Sheet Blank_v2b.xlsm (264.8 KB, 10 views)
Reply With Quote
  #6  
Old 12-19-2017, 07:27 AM
RonLEngle RonLEngle is offline Sorting Problem Windows 7 32bit Sorting Problem Office 2010 32bit
Novice
Sorting Problem
 
Join Date: Jun 2017
Posts: 8
RonLEngle is on a distinguished road
Default

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
Reply With Quote
  #7  
Old 12-19-2017, 09:38 AM
NoSparks NoSparks is offline Sorting Problem Windows 7 64bit Sorting Problem Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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
Reply With Quote
  #8  
Old 12-19-2017, 01:04 PM
RonLEngle RonLEngle is offline Sorting Problem Windows 7 32bit Sorting Problem Office 2010 32bit
Novice
Sorting Problem
 
Join Date: Jun 2017
Posts: 8
RonLEngle is on a distinguished road
Default

awesome that worked, thanks you very much for your help
Reply With Quote
  #9  
Old 12-19-2017, 01:15 PM
NoSparks NoSparks is offline Sorting Problem Windows 7 64bit Sorting Problem Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

You're welcome.
Reply With Quote
Reply

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
Sorting Problem Problem sorting names alphabetically? mikehende Excel 12 09-12-2012 12:00 PM
sorting problem gsrikanth Excel 4 02-16-2012 12:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft