I've attached an example workbook.

Right now, I have it functioning where the report tab will read the data from the DATA tab, then remove duplicates of that data when the "Generate Report" commandbutton is pressed, leaving only one person with the same name listed. I would like to add the option of choosing how many duplicates to remove, leaving a desired amount of persons with the same name listed, if there are that many. For instance, my example includes 4 "joe smith"s, 1 "tracy johnson", and 2 "steve wright"s. I want to be able to choose to leave 2 of each. So that would leave 2 of the "joe smith"s, and the still populate the 1 "tracy johnson" and the 2 "steve wright"s. And/or I want to be able to choose to leave 3 of each, which would then leave 3 of the "joe smith"s and still populate the 1 "tracy johnson" and the 2 "steve wright"s, etc, etc.
Is this possible? if so, how? Thanks!

example.xlsm