Hi,

What would be the best way of building a league table from 75+ teams that automatcially updates itself when I update player scores. The set up of each team looks like this (beginning at A1) with each team recurring every 20th row. Player scores are linked to main players table using vloopup =IF($A2="","",VLOOKUP($A2,Euro2004Players,5,1))

Tony (Manager name occurs in first row, i.e. A1)
Code Player Team Value Point
8 Kahn Germany 4 6
137 Cocu Holland 4
104 R Kovac Croatia 3.5
114 Jensen Denmark 3
132 Worns Germany 4
226 Vieira France 6
202 Petrov Bulgaria 3
250 Astaf Latvia 2.5
321 Henry France 8.5
345 Postiga Portugal 3.5
335 Nistroo Holland 8
Total 50 1

The idea being that my league table would end up looking something like this

Pos Manager Pt
1 Tony 6
2 Chris 5

Very grateful for any ideas or code on how to put this together

Ton