Quote Originally Posted by Hawkeye16 View Post
Could you provide a quick excel file example so we can see formatting and everything?
Also, when you say unique ranges for each person does that mean that no 2 people's ranges overlap?
Can there be duplicates used or should each number be used only once?
How are the unique ranges set or identified for each person?


Sure thing Hawkeye16, i'm sorry, it's sometimes tough to know what information is needed, without Info Overload....


Here is an example with a little more data.
EXAMPLE.xlsx

What I mean by Unique ranges...
The numbers to the right of "PERSON 1", "PERSON 2" etc... are tickets they've logged. I'm trying to choose 10 for each person at random, and list them in a row, PERSON NAME then 10 of their tickets, then the next persons name, and 10 of their tickets and so on untill each person has 10 of their tickets picked at random, a continuous list is fine.

The list will be used to decide which tickets (numbers) should be reviewed, therefore each number should be used only once.

The problems are that the number of people, and the number of tickets in total will change each time this is used. Usually we're choosing from between 8-10 people and we're always looking for 10 random tickets from each person (except where someone doesn't have 10 logged tickets (rare, but possible)).

I'm sorry, but i'm not sure what you mean with the last question. The macro will be run on the data as presented in sheet 1 of the example.

the data is filtered and pulled from a MASSIVE sheet, but although the amount of data may change, the format of it, will always be as in the example.

Hope that clarify's my request.