Dave F - here is my specific question. I have two sheets - TEST One and
TEST Two. In Test One I have 1000 part numbers with 10 columns of data
about that part. In Test Two I have 25 part numbers - I want to know do any
of my 25 parts in Test Two exist in Test One. I want to do this without
having to do 25 finds. If excel can do this, can it produce a third
spreadsheet with the results? For example it finds 10 matches - will it
parse those 10 out in another sheet with the list of the 10 columns of
information? Please advise - thank you in advance for your help.

"Dave F" wrote:

Not that I'm aware of. However, there may be a way to easily compare the two
sets of data. Provide some information on the data you want to compare.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Paul Huelskamp" wrote:

Does anyone know if Excel 2007 has added a feature to compare two worksheets
and highlight differences?

It looks like earlier releases required a third-party addin for this.


Thanks,
Paul