Below is a sample (Example) of the data (3 columns (in case it doesn't show properly)), The amount of data will vary.


- PERSON NAME - - REGION - - TICKET NUMBER -


PERSON 1 AsiaPac 31964190
PERSON 1 AsiaPac 31964221
PERSON 1 AsiaPac 31964229
PERSON 2 AsiaPac 31962860
PERSON 2 AsiaPac 31963051
PERSON 2 AsiaPac 31963093
PERSON 3 AsiaPac 31963107
PERSON 3 AsiaPac 31963352
PERSON 3 AsiaPac 31963476
PERSON 4 AsiaPac 31964154
PERSON 4 AsiaPac 31964166
PERSON 4 AsiaPac 31964176
PERSON 5 AsiaPac 31963325
PERSON 5 AsiaPac 31963330
PERSON 5 AsiaPac 31963382
PERSON 6 AsiaPac 31963021
PERSON 6 AsiaPac 31963155
PERSON 6 AsiaPac 31963327



I need to set ranges for each unique person, then pick 10 random numbers from the 3rd colum (always C) in each of the unique ranges. (Obviously there are only 3 for each above...but there would usually be WAY in excess of 10, however I guess I need to work out how to account for the posiblity that there may be less on some occasions). Also, the number of people will vary too.

I'd like have the data copied into the 4th row (always D), PERSON NAME, then a list of the numbers picked for them, then the 2nd PERSON NAME...

PERSON 1
31964190
31964221
PERSON 2
31962860
31963051
PERSON 3
31963107
31963352
PERSON 4
31964154
31964166
PERSON 5
31963325
31963330
PERSON 6
31963021
31963155


I hope this doesn't prove too complicated, and i'm desperate to learn VBA so if anyone has the time to explain their code examples, I'd would be forever grateful.

Extreme thanks in advance.