One way ..

Try this previous sample for a similar query (details inside):
http://cjoint.com/?cwlDMQRsgf
Compare 2 data sets & extract differences_matsgulis.xls

The construct assumes that the key col data to be compared is placed
side-by-side in cols A and B on a single sheet (you could just copy paste
from your 2 sheets into a new sheet), and extracts out neatly the items in
one set not found in the other set.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Fanney" wrote in message
...
Hi out there.
I wanted to ask if it is at all possible to compare info in one sheet to
info in another sheet (in the same workbook) when double info is not
necessarily located in the same cell in both sheets.

Background: I have one list of files registered in a data base and a list
of
files actually on a hard drive. I need to compare the two list both ways
to
check if there are any files on the drive, not registered in the data base
and, vice versa, if there are any files registered into the data base that
are not on the hard drive.

Any help would be greatly appreciated.