Hello All,

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

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

Thanks
Frank


--
fastfrank
------------------------------------------------------------------------
fastfrank's Profile: http://www.excelforum.com/member.php...o&userid=31365
View this thread: http://www.excelforum.com/showthread...hreadid=510559

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


"fastfrank" wrote in message
...

Hello All,

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

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

Thanks
Frank


--
fastfrank
------------------------------------------------------------------------
fastfrank's Profile: http://www.excelforum.com/member.php...o&userid=31365
View this thread: http://www.excelforum.com/showthread...hreadid=510559

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 if you want to send it to me?

Thanks
Frank


--
fastfrank
------------------------------------------------------------------------
fastfrank's Profile: http://www.excelforum.com/member.php...o&userid=31365
View this thread: http://www.excelforum.com/showthread...hreadid=510559