Retrieve multiple data rows data from a very long list and copy t
 

I need to retrieve multiple data rows data from a very long list and copy
them to another worksheet. The list has over 1000 rows. The rows all have
the unique data but are all have an ID number corresponding to one person, we
have 37. The ID number is in the left most column. Vlookup will find the
first row only. Countif finds the total number of records but how would I
find then copy all the rows of data that corresponds to person number 7? Any
help would be appreciated! Thanks!

Retrieve multiple data rows data from a very long list and copy t
 

Have you tried Autofilter or advanced filter?

"Mathew" wrote:

I need to retrieve multiple data rows data from a very long list and copy
them to another worksheet. The list has over 1000 rows. The rows all have
the unique data but are all have an ID number corresponding to one person, we
have 37. The ID number is in the left most column. Vlookup will find the
first row only. Countif finds the total number of records but how would I
find then copy all the rows of data that corresponds to person number 7? Any
help would be appreciated! Thanks!