OR...
Are you looking for a solution to merely identify and highlight matches
so you can easily find them and view the data? This is what I did to
locate the matches in both sections (using CF). To view the matches
together I split the window vertically and scrolled either or both
panes to align whichever record I wanted.

OR...
In the case of a list of matches only, do you want the list put on a
separate worksheet so the original list remains intact?

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc