The easiest would be to use datafilterautofilter
or look in vba help for FIND and FINDNEXT

--
Don Guillett
SalesAid Software

"ClayShooters" wrote in message
oups.com...
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?