to search and display the top 50s (from the previous 14 sheets) in a new sheet

Hi,
I'm currently creating a data base for my basketball league, what i have is 14 different game sheets which will automatically calculate the total statistics for me including percentage of FG, total rebounds, total assists...etc for each game..
from D4 to Q18 is the data i'll enter the sigle gmae stats (for all players) i recorded from the game... and from S4-CE18 is the accumulate stats which the players involve in (like the avg rebounds they get for one game, the total rebounds they have so far)...
all totals are using previous sheets to get the value (by adding up the previous sheet's total, like =Q5+'Game 13'!CD5...
My question is how can i creat seperate the top 50s page (showing who got the most rebounds and how many in total ) using the data i got from the previous pages which will automatically updated whenever i enter the new game statistics in??
Joy

If you have the accumulated states for each game, why not create an
additional WB or WS that is a DB of all the players and their accumulated
stats. Then just do a descending sort on each of the stat columns. To make
life easier, you can record a macro for each of the different sorts.

"joyjoy329" wrote:

>
> Hi,
> I'm currently creating a data base for my basketball league, what i
> have is 14 different game sheets which will automatically calculate the
> total statistics for me including percentage of FG, total rebounds,
> total assists...etc for each game..
> from D4 to Q18 is the data i'll enter the sigle gmae stats (for all
> players) i recorded from the game... and from S4-CE18 is the accumulate
> stats which the players involve in (like the avg rebounds they get for
> one game, the total rebounds they have so far)...
> all totals are using previous sheets to get the value (by adding up the
> previous sheet's total, like =Q5+'Game 13'!CD5...
> My question is how can i creat seperate the top 50s page (showing who
> got the most rebounds and how many in total ) using the data i got from
> the previous pages which will automatically updated whenever i enter the
> new game statistics in??
> Joy
>
>
> --
> joyjoy329
> ------------------------------------------------------------------------
> joyjoy329's Profile: http://www.excelforum.com/member.php...o&userid=35994
> View this thread: http://www.excelforum.com/showthread...hreadid=557824
>
>

thx for reply... but which formula should i use to get the colum for just the accumulated stats(including their names, which apears in the A colums)?? so that i don't have to copy and paste?? coz i have over 200 players....