I assume you know very well what you want, but I, for one, don't understand it at all.
You've got two worksheets (in the same xls-file?) and you want to compare/search for something between worksheets, that's what I make of it. Please describe your application, and provide an example.
Kees
I am currently trying to search between two Excel Worksheets to match data that may have been entered incorrectly. How can I search partially between the two worksheets to find possible matches? I have a list of about 1000 data sets that I am trying to find matches to. Any help on searching between these two worksheets quickly?
Thanks

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic