Comparing values of two spreadsheets

F

fastfrank

Hello All,

I'm trying to use excel to compare the contents of two seperat
worksheets. My current method includes colouring the old data in on
colour, importing the new data underneath and sorting by one colum
thus differences are highlighted next to each other - achieves th
objective but it's 'very' messy!

Does anyone know of any easy way or native function in excel t
facilitate this?

Thanks
Fran
 
B

Bernie Deitrick

Frank,

You could use a third sheet, and use a formula like this in cell A1:
=IF(Sheet1!A1=Sheet2!A1,"","Changed!")
and then copy that to a large enough block to compare all cells of interest.

But, that will only work if the cells have jsut been over-written, not sorted, added to, etc...

I've written a sheet comparison add-in that will compare two worksheets that have been sorted
vertically, that I will send you if you contact me privately. There are still limitations (the
columns need to be in the same order) but it is useful.....

HTH,
Bernie
MS Excel MVP
 
F

fastfrank

Hi Bernie,

Thanks for your help, thats very useful. The add-in also sounds like
it's worth a go but can't figure out how to private message you.

My email is [email protected] if you want to send it to me?

Thanks
Frank
 
Top