Macro to get random samples based on condition

[Closed]
Report
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
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 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
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