Hey there,

I'm trying to extract key data from a spreadsheet in this way: the
spreadsheet has cells in different columns which may have matching
data. I want Excel to find these matching cells and copy the rows in
which they reside onto a second sheet.

For example:

The first column in question is a listing of Service Orders. I want
Excel to search the second column in question, Purchase Orders, for a
match. When a match or matches are found I want any row containing
that info to be presented on the second spreadsheet.

The example is probably redundant, but hopefully stating it slightly
differently will help illuminate my goal.

Thanks in advance,

Nate


--
ThalesNate
------------------------------------------------------------------------
ThalesNate's Profile: http://www.excelforum.com/member.php...o&userid=31037
View this thread: http://www.excelforum.com/showthread...hreadid=507028