I have been copying random 10% of entire row of data into the new sheet. For example, i have 1000 row of the data, i have to select and copy 10% row of data (which is 100) randomly into the new sheet. Been doing this on weekly basis.
Is there way to do it automatically by selecting and copying 10% of row into the new sheet using VBA Excel?
. It would be great if you can create VBA macro code to detect the entire number of row automatically and select 10% of the row randomly.
I have attached mock spreadsheet attachment and you can use the example to random select 10% of the row into new sheet
Please let me know if you have issue.