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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Process[/TD]
[TD]Group[/TD]
[/TR]
[TR]
[TD]Nickels[/TD]
[TD]MT[/TD]
[TD]Red[/TD]
[/TR]
[TR]
[TD]Tiffany[/TD]
[TD]MS[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]COLEMAN[/TD]
[TD]MQ[/TD]
[TD]Yellow[/TD]
[/TR]
[TR]
[TD]Tomas[/TD]
[TD]MT[/TD]
[TD]Red[/TD]
[/TR]
[TR]
[TD]Hill[/TD]
[TD]AQ[/TD]
[TD]Green[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]MT[/TD]
[TD]Yellow[/TD]
[/TR]
</tbody>[/TABLE]

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