software

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: www.excelforum.com/member.php...oamp;userid=31365
View this thread: www.excelforum.com/showthread...hreadid=510559Frank,

You could use a third sheet, and use a formula like this in cell A1:
=IF(Sheet1!A1=Sheet2!A1,quot;quot;,quot;Changed!quot;)
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 MVPquot;fastfrankquot; gt; wrote in message
...
gt;
gt; Hello All,
gt;
gt; I'm trying to use excel to compare the contents of two seperate
gt; worksheets. My current method includes colouring the old data in one
gt; colour, importing the new data underneath and sorting by one column
gt; thus differences are highlighted next to each other - achieves the
gt; objective but it's 'very' messy!
gt;
gt; Does anyone know of any easy way or native function in excel to
gt; facilitate this?
gt;
gt; Thanks
gt; Frank
gt;
gt;
gt; --
gt; fastfrank
gt; ------------------------------------------------------------------------
gt; fastfrank's Profile: www.excelforum.com/member.php...oamp;userid=31365
gt; View this thread: www.excelforum.com/showthread...hreadid=510559
gt;

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: www.excelforum.com/member.php...oamp;userid=31365
View this thread: www.excelforum.com/showthread...hreadid=510559