Autofilter on the id column, DataFilterAutofilter, and select by your
target id. This will hide all other rows, and you can then copy off the
visible rows.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"larkindale" wrote in message
...
I have a large matrix of data in excel, which is about 20 columns and
22,000
rows. Each row is identified by a unique identifier. I freqently need to
pull out the data for up to 1,000 rows at a time. Is there a function on
excel that would allow me to easily do this without searching for each
identifier individually?