Select Random rows and paste it in a different sheet.

H

Heera

Hi,

I have a database of 10000 rows in excel and i want a macro which will
select either 10% of data randomly or if a number is given (say 1150)
it should select those many number of row from the data base.

After selecting the data it should paste the data in a different
sheet.

I dont know how to use the rand() function in VBA. Can sum one help me
with the code.

Regards
Heera
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random selection of rows. 2
Found few bugs in my daily routine of work in excel for MAC 0
Found few bugs in my daily routine of work in excel for MAC 0
Macro to select and delete levels of a document 2
Creating a Search using a combo box and then creating a report. 4
Need Help with a VBA subroutine 0
hidden rows, column copy-paste 0
MACRO RUN random percentage and copy of column values 1

Top