VBA: Sort and report to a form

[D3Pratt]

Thanks to everyone that has been helping me with this project so far, and this forum in general has solved many more issues than I ever expected to encounter, fantastic resource.


Finally, on the final stretch towards completion.

From the sample file, I am using the data on (start) worksheet.

(Sort and report sheet)
I'm after a reporting routine that I want to run on the launch of a Userform. What it would do in an ideal world is when I click the "launch report" (command) button in Excel, it would look at a sheet (start), and extract the top 5 values from the sheet, both for the overall list, and the top 5 values per unique name, then returns that data to the Userform for viewing only.

[rylo]

Hi

See how the attached file goes.

rylo

[D3Pratt]

Thanks for the reply!

Turns out I marked the wrong thread solved :\

I actually solved this using a combination of Sort and advanced Filter. I don't have the code in front of me to post it up.

In summary I recorded a macro then tweaked it. The end result was a series of mini-macros strung together as the core of a userform initialize, I got the exact result I needed. It works, not very elegant, and I'm sure there is about 40% bloat in the code. But like I said, it works.