I am working on some excel data where in need to randomly select 5 (or 10) equal number of data from different user and display in a different sheet. As it is big sheet it becomes a time taking process, and for that I am looking to get a VBA which may go ahead and select random data and display.
Eg: (need to randomly select 3 data from each user A0123 and B0123)
<tbody>
</tbody>
Kindly suggest as how to go ahead with it. Thanks to all in advance.
Eg: (need to randomly select 3 data from each user A0123 and B0123)
User | Data1 | Data2 | Data3 | Data4 |
A0123 | 123501 | 12457 | 547896 | 546231 |
A0123 | 4568453 | 2156465 | 5445445 | 7545565 |
A0123 | 9013405 | 4300473 | 10342994 | 14544899 |
A0123 | 13458357 | 6444481 | 15240543 | 21544233 |
A0123 | 17903309 | 8588489 | 20138092 | 28543567 |
A0123 | 22348261 | 10732497 | 25035641 | 35542901 |
A0123 | 26793213 | xbcs | 29933190 | 42542235 |
A0123 | 31238165 | 15020513 | 34830739 | 49541569 |
B0123 | 35683117 | 17164521 | 39728288 | 56540903 |
B0123 | 40128069 | 19308529 | ytytt | 63540237 |
B0123 | 44573021 | fhghg | 49523386 | 70539571 |
B0123 | 49017973 | 23596545 | 54420935 | 77538905 |
B0123 | 53462925 | 25740553 | 59318484 | fgfgfg |
B0123 | sadsd | 27884561 | 64216033 | 91537573 |
B0123 | 62352829 | 30028569 | 69113582 | 98536907 |
B0123 | 66797781 | 32172577 | 74011131 | 105536241 |
<tbody>
</tbody>
Kindly suggest as how to go ahead with it. Thanks to all in advance.