How do I reconcile two sheets with in a .xls book?

  • Thread starter Thread starter Guest
  • Start date Start date
If by reconcile, you are referring to values within cells and that th
two sheets are identical in format, on a 3rd sheet enter a formula fo
example, in cell A1 "=Sheet1!A1-Sheet2A1". If the result is not zero
then there are different amounts in the cells. Copy the formula acros
the range you wish to compare to highlight the variances.

Does this answer your question
 
Back
Top