Excel help with sorting

[ads25]

Hi all,

Just a quick question in regards to sorting a table on Excel. Is it possible to sort a table like you can on some websites by clicking on the header of each column. For example i just made up this table:

Team	P	W	L	D	Pts
Chelsea	20	19	0	1	58
Liverpool	20	15	2	3	48
Man Utd	20	12	1	7	43
Arsenal	20	10	5	5	35

So if i click on say 'W' then i can sort the table by the wins, or if i click on 'L' i can sort it by losses etc.

Cheers

[Hands Solo]

Originally Posted by ads25

Hi all,

Just a quick question in regards to sorting a table on Excel. Is it possible to sort a table like you can on some websites by clicking on the header of each column. For example i just made up this table:




So if i click on say 'W' then i can sort the table by the wins, or if i click on 'L' i can sort it by losses etc.

Cheers

As you know mate, I don't know much about Excel. But I am under the impression that by clicking on either A-Z Ascending or A-Z Descending, that it would rearrange that column from either highest to lowest or lowest to highest.

[tipstar]

highlight Team to pts
then go to toolbar and click data.
from the dropdown menu click filter then autofilter.
This will put dropdown boxes in team through to pts
click on the one you want to sort and it gives you you options.

[ads25]

Originally Posted by Crouch Potato

As you know mate, I don't know much about Excel. But I am under the impression that by clicking on either A-Z Ascending or A-Z Descending, that it would rearrange that column from either highest to lowest or lowest to highest.

Yeh i know how to do it that way and ive set up different macros to enable me to sort my tables the way i want to. But i want to be able to sort a table just by clicking on the header of the page without having to make up all these macros.

Im not sure that Excel allows this function though

[ads25]

Overall Ladder
#		P	W	L	Avg F	Avg A	Pts%	WR%
1	Bullets	24	19	5	112	100	112.2	79.2%
2	Wildcats	25	18	7	100	92	108.5	72.0%
3	Tigers	24	17	7	104	100	104.7	70.8%
4	Crocodiles	27	17	10	110	106	103.8	63.0%
5	Kings	25	15	10	100	96	103.4	60.0%
6	Taipans	26	14	12	100	99	100.6	53.8%
7	Dragons	26	12	14	103	105	97.7	46.2%
8	Slingers	25	10	15	100	103	96.8	40.0%
9	36ers	26	10	16	100	105	95.5	38.5%
10	Hawks	24	9	15	101	104	97.1	37.5%
11	Breakers	25	7	18	102	108	94.1	28.0%
12	Razorbacks	25	3	22	98	110	88.9	12.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

[tipstar]

cant see why autofilter cant do it ?
see my post above

[Hands Solo]

I had a look around and this seems to the job, though it might not be what you're after:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim LRow As Long '-- double-click on column to sort
'Find last row in Column A with content
LRow = Cells(Rows.Count, 1).End(xlUp).Offset(0, 0).row
Rows("2:" & LRow).Sort Key1:=Cells(2, ActiveCell.Column), _
Order1:=xldescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
End Sub

Just change the column letter for the respective statistic that you are sorting