I have got golf scoring spreadsheet. (gross, net and stableford)

I've got it nicely sorted out for overall scoring, but now want to have 4
seperate result tables, depending on what grade the player is in - so
therefore, i want the spreadsheet to automaticaaly enter all the grade 1's in
the grade 1 result table, all the grade 2's in the grade 2 result table and
so on!

it would be nice to do this without having to do it manually, and without
any gaps between the players. (i.e. which i could probably do by doing a
simpe "if" formula.


it seems to me that the answer will be in some sort of loop that i see you
clever people writing about, but that I'm not clever enough to get my head
around!

Any help greatly appreciated, thank you!

let me know if i need to explain it a little more clearly!



Mike