If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I reconcile two sheets with in a .xls book?
How do I reconcile two sheets with in a .xls book?
|
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cannot access Address Book for use in emails / rules | Tenacity | General Discussion | 2 | October 7th, 2005 08:47 PM |
OUTLOOK EXPRESS PROBLEMS WITH ADDRESS BOOK | PA Bear | Outlook Express | 16 | June 10th, 2005 06:06 AM |
Improve the Address Book | Bill Molony | General Discussions | 10 | February 17th, 2005 11:49 PM |
Copying multiple sheets to a new book and undertake specialised ed | Pank Mehta | General Discussion | 0 | February 8th, 2005 12:03 PM |
How to reconcile (tally items) in two sheets of an excel workbook. | Reconciliation | General Discussion | 2 | September 30th, 2004 12:35 PM |