sugat11
07-05-2016, 08:01 AM
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
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