Macro to get random samples based on condition

Closed
spraud - Oct 3, 2016 at 11:53 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Oct 3, 2016 at 12:04 PM
How to create a macro which picks random 200 rows from a excel file which has huge data. Each column containing both empty and valued data.

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Oct 3, 2016 at 12:04 PM
Hi Spraud,

May this link guide you to your solution:
https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/rnd-function

If your solution is stil out of reach, then let us know what you want to do with the randomly picked rows.

Best regards,
Trowa
0