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