macro for top10 and wors10 in ranking
 

Is there a way do a macro to ...extract the top10 and worst10 people from a
ranking?

I have a worksheet with 200+ employees, they all have 5 measures and based
on their scores they are assigned points and when points are added, a ranking
is made.

I have my formulas for the points and ranking done & I can identify the
top10 and worst10 in column G using the SMALL and LARGE formulas but ...I
need to somehow extract/copy the whole rows for the top10 and worst 10 and
paste them into a new sheet?? can that be done?

it looks like this but will 200+ rows

A B C D E F G
1 Name Score1 Score2 Score3 Score4 Score5 RANK
2 mika 85% 90% 30% 2% 55% 5
3 tetsu 94% 92% 50% 1% 88% 1
4 shouji 95% 33% 26% 7% 44% 9

Cheers,
Mayte