| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I reconcile two sheets with in a .xls book?
How do I reconcile two sheets with in a .xls book?
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula adding cells in worksheets when # of sheets in work book changes | Excel Discussion (Misc queries) | |||
| Archiving .XLS Sheets | Excel Discussion (Misc queries) | |||
| .xls to OE address book | Excel Discussion (Misc queries) | |||
| Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
| Copying multiple sheets to a new book and undertake specialised ed | Excel Discussion (Misc queries) | |||
Linear Mode
