Yours would take a relatively elaborate macro to check each State item on
sheet 2 and see if it existed in the State column in Sheet 1 and if so run a
Autofilter on that criteria and copy and paste those results to another
"Report" sheet, then clear the autofilter and then step down and do the same
thing with each item in State on sheet 2 and append each Autofilter results
to the bottom of the Report sheet list.....
It is definately do-able, but only justified if you have do do this exercize
frequently.....

hth
Vaya con Dios,
Chuck, CABGx3






"mrbernz" wrote in
message ...

I have a question similiar. Basically one sheet has multiple columns
each holding different information about an item. Each item has its own
row. On another sheet I have one column that shares a name with one of
the columns on the previous sheet.

Sheet 1
Name Phone Address City State Zip
Jon Doe 555555 newhere nowhere st 55555
Jon Doe2 555555 newhere nowhere ni 55555
Jon Doe2 555555 newhere nowhere st 55555
Jon Doe3 555555 newhere nowhere st 55555
Jon Doe4 555555 newhere nowhere me 55555

Sheet 2
State
st
ni

What I would like to do is filter the state column on Sheet 1 by the
contents of the State column on sheet 2. A couple issues are Sheet 2 is
pulling data from a web query so the contents will change. Meaning
sometimes it might pull only two items, another time it may be 20 or
more.


--
mrbernz
------------------------------------------------------------------------
mrbernz's Profile:
http://www.excelforum.com/member.php...o&userid=32814
View this thread: http://www.excelforum.com/showthread...hreadid=526208