| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select Random rows and paste it in a different sheet.
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a new sheet containing random sampler 200 rows over 2000 | Excel Worksheet Functions | |||
| Alternate Row Select in Sheet 1 then Paste to Sheet 2 | Excel Worksheet Functions | |||
| Select and then cut and paste rows based on a value in 1 cell of t | Excel Programming | |||
| copying random rows in excel to another sheet | Excel Programming | |||
| Select rows with certain values, cut, paste into new worksheet | Excel Programming | |||
Hybrid Mode
