[Closed] Comparing Excel spreadsheets

not pretty but make a working copy of one of the files.

assuming that each sheet isnt more than half as wide as a worksheet limit, copy the contents of the second matching worksheet and paste the data next to the first set of data.
then use conditional formatting to flag up content differences.

this assumes that a) the contents of the sheet need no more than 50% of the rows available in the worksheet and b) that the two files are structurally identical (i.e. no new rows inserted)

Try this:

http://www.formulasoft.com/xlsc.html

I have a nice bit of VBA that compares each row in a SS line by line.

But I cant send it to you 🙁 for obvious reasons.

thanks tragic