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

G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Obtaining Unique Number From Data Validation List 5
Combining data from multiple rows 2
Filtering of data in a master excel sheet from multiple sheets 3
Question about copying long rows of data 2
Copy non adjacent rows 3
Retrieve data with MAX and VLOOKUP 1
Copy data from unlocked cells 3
copy rows from one Data sheet to another sheet based on cell conte 2

Top