random sampling pick based on criteria in excel VBA

[Dhanabalan]

Hi All,

I new to vba, I need the code for random sample pick based on criteria

Name	Process	Group
Nickels	MT	Red
Tiffany	MS	Green
COLEMAN	MQ	Yellow
Tomas	MT	Red
Hill	AQ	Green
John	MT	Yellow

<tbody>
</tbody>

columns A has Name columns B has Process Columns C has Group like that i have more than 100 rows

I need to pick sample based on criteria as Group in columns C - Red 4% , Yellow 3% and Green 3% total 10% of rows in sheet 1 and sample data need to paste in sheet 2

Please help on this.

 

[shg]

There's an example of how to do it using formulas at https://www.mrexcel.com/forum/excel-questions/1069702-random-sampling.html

 

[Dhanabalan]

Thanks for the information but i need to Vba code for that because its many people they not understand the formula, If macro i link with some box or short cut