Macro to get random samples based on condition

Closed
spraud - 3 Oct 2016 à 11:53
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 3 Oct 2016 à 12:04
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
3 Oct 2016 à 12:04
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