I am having some problems with a workbook for entering scores for
archery competitions and giving the resultant medals. i can do the
individual medals by using command buttons and macros assigned to them
which filter and then order the people from highest to lowest in three
categories.

The problem is in calculating the team scores and medals, preferably
in a seperate worksheet, by taking the top four experienced and novice
scores for each team, adding them together and then tabulating them in
the correct order for each of the categories.

e.g.

Experienced
Team1 - 2305
team2 - 2286
Team3 - 2254 etc

I would quite like it if somone could direct me to a macro that could
do this via a command button in the results sheet, (i.e press button
and generate table on the sheet by collecting data in master
scoresheet). I was looking down the avenue of using RANK, but I am not
sure about this as whenever a button gets pressed to filter the
results to certain categories, the non-relevant cells merely become
hidden and i'm not sure RANK will work this way, and anyway, i do much
prefer macros, even though I am very much a beginner to them.

If the file would help, I can post a link to it later as I do not
currently have the latest copy with me.