Hello

Please help.

I'm trying to program Excel to run down a column of values, taking the top
10 highest values and populating another worksheet with the adjacent
reference for these values.

For example

If I have company registration numbers in one column and their corresponding
credit risk ratings in another column, I want excel to populate another
worksheet with the registration numbers of the top 10 most risky companies .

I can do this manually, but I want add a button so that my colleagues can
perform the same action with exactly the same result.

Any hints would be much appreciated and I would be willing to make a donation

Many thanks in advance, Nick