Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Sorting query
Hi, I'm very new to Microsoft Excel, and all I know is primarily self taught, as in my course we focussed on the use of Microsoft Access instead. Anyway, my query is as follows: I've made a spreadsheet for the football world cup. I have one sheet with the fixtures in, and one with the groups that take data from the fixtures to make the group tables. My problem with the sorting is as follows: Because of the way the groups are done, I've got them sorted firstly by points descendingly, secondly by goal difference, then thirdy by goals scored. When I enter results for the fixtures in the first sheet, it updates the table for results and points, but doesn't update the sorting. I have to go Data - Sort and press OK again for it to Sort again. Is there any way to update Sort automatically? Thanks for any help. -- thebottomline ------------------------------------------------------------------------ thebottomline's Profile: http://www.excelforum.com/member.php...o&userid=35290 View this thread: http://www.excelforum.com/showthread...hreadid=550780 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Sorting query
i'd link this to button, so that after you have enterred all your
scores you can update Sub Reordertables() Sheets("Sheet2").Activate Selection.Sort Key1:=Range("G2"), Order1:=xlDescending, Key2:=Range("F2") _ , Order2:=xlDescending, Header:=xlGuess, OrderCustom:=1, MatchCase:= _ False, Orientation:=xlTopToBottom End Sub I assume you have more than one table though. I'd say record a macro while you perform the task and see what code is generated. somethinglikeant thebottomline wrote: Hi, I'm very new to Microsoft Excel, and all I know is primarily self taught, as in my course we focussed on the use of Microsoft Access instead. Anyway, my query is as follows: I've made a spreadsheet for the football world cup. I have one sheet with the fixtures in, and one with the groups that take data from the fixtures to make the group tables. My problem with the sorting is as follows: Because of the way the groups are done, I've got them sorted firstly by points descendingly, secondly by goal difference, then thirdy by goals scored. When I enter results for the fixtures in the first sheet, it updates the table for results and points, but doesn't update the sorting. I have to go Data - Sort and press OK again for it to Sort again. Is there any way to update Sort automatically? Thanks for any help. -- thebottomline ------------------------------------------------------------------------ thebottomline's Profile: http://www.excelforum.com/member.php...o&userid=35290 View this thread: http://www.excelforum.com/showthread...hreadid=550780 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Sorting query
I would suggest using the record macro function to record the manual sorting operation and then copy the code into the worksheet_activate event macro for the second sheet. This way, every time you switch to the second sheet, a sort will be done automatically. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=550780 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Sorting query
Cheers mrice, that sounds the best way to do it, everytime i go onto the sheet it happens. how would i go about doing that? -- thebottomline ------------------------------------------------------------------------ thebottomline's Profile: http://www.excelforum.com/member.php...o&userid=35290 View this thread: http://www.excelforum.com/showthread...hreadid=550780 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Sorting query
Use macro-record macro on the tools menu. Then paste into the sheet1 tab where you have selected worksheet and activate in the boxes at the top. -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=550780 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing query source | Excel Worksheet Functions | |||
AHHH! Again | Excel Discussion (Misc queries) | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
"Query cannot be edited by the Query Wizard" | Excel Discussion (Misc queries) | |||
Very basic query | New Users to Excel |