Sampling

[hmc]

I am trying to past sample results into a new worksheet; however, I need the
whole row to come over.
Example:
10 columns
10 rows

*random sampling of 5; howver, I need the whole row to come over

Everytime I do it, it states it can't bring over numeric data is there
something else I can try to any other options?

 

[Gary''s Student]

Here is a neat trick to sample entire rows. You will need two helper columns
(Y&Z).

Say we have data in rows 1 thru 100 and we want to sample 5 rows.

In Y1 thru Y5 enter 1
In Y6 thru Y100 enter 0
In Z1 thru Z100 enter =rand()

Then sort cols Y & Z by column Z. This will scatter the 1's down the
column. If you switch on AutoFilter, you can pick out the rows with the 1's.
Just copy/paste the visible rows. To get a new sample switch off the
AutoFilter, re-sort, and re-filter.