Search one worksheet for values in another worksheet?

C

ClayShooters

I have two worksheets and would like to be able to parse a column of
data in the first worksheet and search for each value contained in the
column in the second worksheet. If it is located, it would take the
entire row from the second worksheet and copy it to a third worksheet.
This would basically create a new worksheet containing only rows of
data from the second worksheet which contained a value listed in the
first. Is this possible?
 
D

Don Guillett

The easiest would be to use data>filter>autofilter
or look in vba help for FIND and FINDNEXT
 

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

Top