I have a workbook that will have information about different users and am trying to copy the top users in different categories to another sheet.

Right now, I have my macro set to go into the worksheet and sort the workbook based on the criteria I am interested in. I have the number of "top users" on a different sheet, and I want to be able to select the number of rows that corresponds to the number of top users, copy it, and paste it into another sheet.

For example, one of the categories is Questions Asked. For a specific date, there were 49 top question askers (this value is given in cell F31 on the sheet "Question Distribution"). In the sheet where all the data is, "Daily Activity," I have the macro sort the question category, and then I want to select the top 49 rows, copy the information in those rows, and paste them to a new sheet "Top Questions". But should the value in cell F31 change, I want it to select that many rows instead.

Is this possible?