Eeeewwww.... Excel does not have a "Compare Documents" function.
But Word does... This is messy, but it works...
Use File>Save As to save both worksheets as "Space delimited Text (.prn)"
Now open one of them in Word, and use Tools Compare Documents to compare it
with the other.
Each difference will be marked in red.
Hope this helps
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I have an old inventory and a new inventory and I want to compare the two
spreadsheets. I want to see what rows are on one spreadsheet and not on the
other and I also want to see what rows have differences between the two
documents.
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:
[email protected]
