hi,
see this site.

http://www.cpearson.com/excel/duplic...#InOneNotOther

FSt1

"grahamo" wrote:

Hi,

I am running tests here that involve comparing two excel spread sheets.
right now we have to manually open the files, copy and paste the contents of
each into a separate too, and run a compare. This is time consuming as it
involves an awful lot of manual intervention. Ideally, I would like to run
some sort of command that takes the two files as params and which outputs
(preferable in some sort of graphical format) the differences between the two
files. Is that possible? Or am I asking too much?

thanks much and have a nice day

Graham