Copy the formula from A1 into all the other cells that represent the range you want to compare.In cell A1 of the first worksheet in Compare.xls, enter the following formula:.Create a new workbook called Compare.xls.
If the worksheets in each workbook are laid out the same, and you just want to find differences between values in the cells of each worksheet, then you can use formulas to compare worksheets. There are third-party programs available that can help you out, and a quick search of the Web can help to locate such programs.ĭepending on your needs, there can be an easier way. Unfortunately, there is no built-in comparison feature, as there is in Word to compare two documents. Krishna asked if there was a way to compare the contents of two Excel workbooks.
