VBA to copy random record from a range

[sugat11]

Hi,

I have a table as below

ID name mark age Gender
1 aa 33 11 M
2 aa 64 23 f
3 aa 33 44 f
4 bb 55 23 f
5 bb 88 45 m
6 cc 99 22 m
.......

SO need vba code to copy the random 5 records from Name group.


so output will be any 5 records from aa , any 5 records from bb and continues ......... to copy that data in another sheet

[mdmackillop]

Can you post a sample workbook showing your layout with a usable sample dataset and desired result.