Macro to get random samples based on condition [Closed]

Report
-
Posts
2718
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 15, 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
2718
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 15, 2021
459
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!