Chip Pearson's page on duplicates has many methods/suggestions.

http://www.cpearson.com/excel/duplicat.htm

I suspect you could adapt some of them to work on multiple workbooks.

--
Regards,
Tom Ogilvy


"Robert Poole" wrote in message
...
Does any one know a formula, script, or a macro which
checks through multiple excel files and searches for
identical entries.