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