Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing values of two spreadsheets
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I break values apart that are in the same cell? | Excel Worksheet Functions | |||
Comparing Two Spreadsheets | Excel Worksheet Functions | |||
Comparing cell values then labeling them based on comparision | Excel Discussion (Misc queries) | |||
Comparing a value to a list of values does not work in Excel 2003. | Excel Worksheet Functions | |||
Incorrect SUM Values in Excel Spreadsheets | Excel Worksheet Functions |