Sort Table Problem

[LenaH]

Dear all,

I have a problem I can't solve in sorting a table. The table looks like this and I would like to sort after TOTAL in Col "C".
Sorting within Excel doesn't work, so VBA is probably the way to go.

Unfortunately, I have no idea, how and where to start, since my VBA knowledge is nearly nonexistent

Tourney.xlsm
	A	B	C	D	E	F	G	H	I	J
4	Rank	Team	Total	Player Name	Series 1	Series 2	Series 3	Series 4	Series 5	Subtotal Player
5	1	USA 1	12932	Peter McNamara	727	1500	1289	0	0	3516
6			12932	Eve Dori	1353	782	1161	0	0	3296
7			12932	Christina Huisman	928	1466	728	0	0	3122
8			12932	Jochen Peters	1209	731	1058	0	0	2998
9	2	France 1	12960	Guy Jensen	1166	1162	1422	0	0	3750
10			12960	Peter McNamara	727	1500	1289	0	0	3516
11			12960	Angela Merkl	938	710	1271	0	0	2919
12			12960	Michael Chicken	849	847	1079	0	0	2775
13	3	France 2	3750	Guy Jensen	1166	1162	1422	0	0	3750
14
15
16
17	4	Germany 1	12641	Peter McNamara	727	1500	1289	0	0	3516
18				Gerd Rainberg	803	1230	1195	0	0	3228
19				Christina Huisman	928	1466	728	0	0	3122
20				Michael Chicken	849	847	1079	0	0	2775
21	5	Germany 2	12123	Gerd Rainberg	803	1230	1195	0	0	3228
22				Christina Huisman	928	1466	728	0	0	3122
23				Jochen Peters	1209	731	1058	0	0	2998
24				Michael Chicken	849	847	1079	0	0	2775
25	6	USA 2	12589	Peter Hoffmann	657	1162	1422	0	0	3241
26				Gerd Rainberg	803	1230	1195	0	0	3228
27				Steve Austin	928	1466	728	0	0	3122
28				Jochen Peters	1209	731	1058	0	0	2998
29	7	Canada 2	13511	Guy Jensen	1166	1162	1422	0	0	3750
30				Ron Link	918	1230	1195	0	0	3343
31				Eve Dori	1353	782	1161	0	0	3296
32				Steve Austin	928	1466	728	0	0	3122
TeamStandings

Cell Formulas
Range	Formula
D5	D5	=IF(B5="","",VLOOKUP($B$5,$L$157:$P$177,2,FALSE))
E5:E32	E5	=IF(($D5)="","",VLOOKUP($D5,PlayerPool!$D$2:$L$151,4,FALSE))
F5:F32	F5	=IF(($D5)="","",VLOOKUP($D5,PlayerPool!$D$2:$L$151,5,FALSE))
G5:G32	G5	=IF(($D5)="","",VLOOKUP($D5,PlayerPool!$D$2:$L$151,6,FALSE))
H5:H32	H5	=IF(($D5)="","",VLOOKUP($D5,PlayerPool!$D$2:$L$151,7,FALSE))
I5:I32	I5	=IF(($D5)="","",VLOOKUP($D5,PlayerPool!$D$2:$L$151,8,FALSE))
J5:J32	J5	=IF(D5="","",SUM(E5:I5))
D6	D6	=IF(B5="","",VLOOKUP($B$5,$L$157:$P$177,3,FALSE))
D7	D7	=IF(B5="","",VLOOKUP($B$5,$L$157:$P$177,4,FALSE))
D8	D8	=IF(B5="","",VLOOKUP($B$5,$L$157:$P$177,5,FALSE))
D9	D9	=IF(B9="","",VLOOKUP($B$9,$L$157:$P$177,2,FALSE))
D10	D10	=IF(B9="","",VLOOKUP($B$9,$L$157:$P$177,3,FALSE))
D11	D11	=IF(B9="","",VLOOKUP($B$9,$L$157:$P$177,4,FALSE))
D12	D12	=IF(B9="","",VLOOKUP($B$9,$L$157:$P$177,5,FALSE))
D13	D13	=IF(B13="","",VLOOKUP($B$13,$L$157:$P$177,2,FALSE))
D14	D14	=IF(B13="","",VLOOKUP($B$13,$L$157:$P$177,3,FALSE))
D15	D15	=IF(B13="","",VLOOKUP($B$13,$L$157:$P$177,4,FALSE))
D16	D16	=IF(B13="","",VLOOKUP($B$13,$L$157:$P$177,5,FALSE))
D17	D17	=IF(B17="","",VLOOKUP($B$17,$L$157:$P$177,2,FALSE))
D18	D18	=IF(B17="","",VLOOKUP($B$17,$L$157:$P$177,3,FALSE))
D19	D19	=IF(B17="","",VLOOKUP($B$17,$L$157:$P$177,4,FALSE))
D20	D20	=IF(B17="","",VLOOKUP($B$17,$L$157:$P$177,5,FALSE))
D21	D21	=IF(B21="","",VLOOKUP($B$21,$L$157:$P$177,2,FALSE))
D22	D22	=IF(B21="","",VLOOKUP($B$21,$L$157:$P$177,3,FALSE))
D23	D23	=IF(B21="","",VLOOKUP($B$21,$L$157:$P$177,4,FALSE))
D24	D24	=IF(B21="","",VLOOKUP($B$21,$L$157:$P$177,5,FALSE))
D25	D25	=IF(B25="","",VLOOKUP($B$25,$L$157:$P$177,2,FALSE))
D26	D26	=IF(B25="","",VLOOKUP($B$25,$L$157:$P$177,3,FALSE))
D27	D27	=IF(B25="","",VLOOKUP($B$25,$L$157:$P$177,4,FALSE))
D28	D28	=IF(B25="","",VLOOKUP($B$25,$L$157:$P$177,5,FALSE))
D29	D29	=IF(B29="","",VLOOKUP($B$29,$L$157:$P$177,2,FALSE))
D30	D30	=IF(B29="","",VLOOKUP($B$29,$L$157:$P$177,3,FALSE))
D31	D31	=IF(B29="","",VLOOKUP($B$29,$L$157:$P$177,4,FALSE))
D32	D32	=IF(B29="","",VLOOKUP($B$29,$L$157:$P$177,5,FALSE))
C5,C29,C25,C21,C17,C13,C9	C5	=IF(D5="","",SUM(J5:J8))
C6,C10	C6	=C5
C7,C11	C7	=C5
C8,C12	C8	=C5
B5	B5	=L157
B9	B9	=L158
B13	B13	=L159
B17	B17	=L160
B21	B21	=L161
B25	B25	=L162
B29	B29	=L163

I hope, some of you cracks can help me, solving it?

Lena

 

[Joe4]

You cannot sort it in Excel or with VBA because you data range apparently contains merged cells in columns A and B.
Merged cells, are bad, bad, bad and cause all sorts of problems for Excel, and especially VBA.
You should really avoid using merged cells, whenever possible, or else you will run into these sort of problems.
Personally, I avoid them like the plague!