View Single Post
Old 15-01-2007, 08:37   #5 (permalink)
ads25
The Real Deal ©
 
ads25's Avatar
 
Join Date: 27 Jul 2006
Location: Australia
Age: 24
Posts: 2,721
Default Re: Excel help with sorting

Overall Ladder
#PWLAvg FAvg APts%WR%
1Bullets24195112100112.279.2%
2Wildcats2518710092108.572.0%
3Tigers24177104100104.770.8%
4Crocodiles271710110106103.863.0%
5Kings25151010096103.460.0%
6Taipans26141210099100.653.8%
7Dragons26121410310597.746.2%
8Slingers25101510010396.840.0%
936ers26101610010595.538.5%
10Hawks2491510110497.137.5%
11Breakers2571810210894.128.0%
12Razorbacks253229811088.912.0%



These are the tables im trying to sort, all my NBL ones. This is the first of 10. Ive set up a macro which sorts every single table on the page firstly by % then by Win Ratio and it does them all at once. I made up a command box and assigned this macro to it.

But what i also want to be to do is click is just say for example i want to sort the table above by games won, if i click the 'W' on the header is it possible to have like a link thing which will enable similar to the table in this link

Or even better, how would i upload them to a webpage and have them with sortable headers like in this link again
ads25 is offline   Reply With Quote