Copy random rows

[leader2k]

Hi
How to copy random rows without duplicates from one sheet to another in vba?
your help will be appreciated

[JBeaucaire]

'RANDOMIZATION OF LIST or RANDOM SELECTIONS FROM A LIST
This can be done by macro or by formula. This page shows examples/techniques of both. (example files demonstrate each method)
https://sites.google.com/a/madrocket.../randomization


Option 2 is the simplest in my mind or possibly a combination of the two?

[kalak]

ad hoc code

Please Login or Register  to view this content.

Copies random rows from the used range on active sheet (if not sheet2) to Sheet2.
Number of copies here is 5 (on second line). You can change this directly, or by input box, or however you like.

[leader2k]

Thanx a lot i appreciate the help.
My regards