Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic sorting of a league table once a result has been entered
Hello Readers,
Could somone let me know how I can automatically sort a league tabl once a result has been entered. I can get the table to updat automatically but not sort in to correct order. Thanks in advanc -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic sorting of a league table once a result has been entered
Hi gates;
Use the macro recorder with realative references turned on to create a macro. Then make a button on the work sheet and assign the macro to the button. After you information is refreshed you'll be able to click on the button to automatically sort the information. When the macro is recorded you will probably need to change the slect statement to Range("A1").select Activecell.CurrentRegion.Select Thanks, Greg -----Original Message----- Hello Readers, Could somone let me know how I can automatically sort a league table once a result has been entered. I can get the table to update automatically but not sort in to correct order. Thanks in advance --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
League table | Excel Discussion (Misc queries) | |||
Sorting Tied Teams in League Table by Matches Between Themselves | Excel Discussion (Misc queries) | |||
Automatic Sorting of Top Ten values in a table | Excel Discussion (Misc queries) | |||
League table automatic sort/update | New Users to Excel | |||
Automatic League Sort | Excel Worksheet Functions |