have a table with 12 columns (A:J) with the 11th column containing the user score and the 12th column containing the user rank. I have created a separate sub to sort the data as necessary. I am attempting to create a new sub to run after the sorting sub that would select the highest or lowest n (e.g. 3) values and then paste the associated rows in a separate sheet in the same workbook.
A sample of the dataset can be seen here:
FPGlE.png
I'm a newbie in VBA and programming. Any help would be appreciated.
The attempted VBA code (DID NOT WORK) has been added below
Bookmarks