Life is usually much simpler if you keep your data in one location.

I'd just use one worksheet, but then apply Data|Filter|Autofilter to see the
rows I want to see.

But if you really, really want...

Debra Dalgleish and Ron de Bruin have samples that you may like. Ron's addin
may be sufficient right out of the box.

Debra's site:
http://www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

And Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

ThalesNate wrote:

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

--

Dave Peterson