Hi Kharrison,

Don't know what the sampling feature is, so I don't know what you did.
Perhaps you simply had to select all of the cells.

You could create a new column
K1:K6 on number to each cell 1, 2, 3, 4, 5 ,6
Select K1:K6 and fill down

Use automatic filter and select value of 1
Select all cells (ctrl + A)
Data, Filter, Auto Filter
click on the arrow at the top of the added column,
and select 1 -- which would include the header row if you have a
one row hader.

You can paste the filtered data to another worksheet.-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"kharrison" wrote in message ...
I have multiple columns of data which consist of numeric and text. There are
15000 rows of which I wish to extract a sample of 2500 rows. When I use the
sampling feature it only gives me an extract of the first column of data
which is numeric. How can I get Excel to bring the rest of the data in the
other columns across with it.

If that is not possible, how do I then go about matching up the extracted
numerics with the numerics in the original range.

Regards
Kharrison