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

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

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

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

define reconcile

gls858

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

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

Does this answer your question?


--
Stuart Farr
------------------------------------------------------------------------
Stuart Farr's Profile: http://www.excelforum.com/member.php...nfo&userid=478
View this thread: http://www.excelforum.com/showthread...hreadid=495593