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

S

Stuart Farr

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reconciling two documents in Word 1
How to break up a book's endnotes by chapter in a file containing a whole book? 0
How do I enter Revenue. 0
Design to reconcile accounts 2
Reconciling 3
Missing address Book 0
How to Reconcile Two OnOpen Conditions in a Report? 0
how do i reconcile data in cells from old to new spreadsheet 1

Top