Hi,

I'm posting this thread as part of a random sampling requirement for a process. I've posted in this forum earlier for this and the related thread link are as below:

Filter & Flag as Sample
Randomly Select Data in Excel

As requested by Marvin, i'm posting this thread for a code review, probably, i can explain my code line by line if required. I've posted my code and sample workbooks in the above threads. The main idea is to randomly select rows of data for each user one after another. The records of each user are filtered out and from the filtered set of rows, i need to choose a certain number (say x% of total visible rows) of rows as samples and mark them.