| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
to keep a running balance
What I want to do is take the balance from a previous worksheet, in the same
work book and subtract from that balance. Help!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to keep a running balance
Not sure is I completely undeerstand the question but my gusee is that the
following would meet your need: =Sheet2!A1-Sheet1!A1 This assumes that the balance from the previous worksheet is still named Sheet1 and the balance that you need to deduct is in cell A1 from that page. It also assumes that you are subtracting the balance from cell A1 on Sheet2. Hope it helps. "johnilee" wrote: What I want to do is take the balance from a previous worksheet, in the same work book and subtract from that balance. Help!!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to keep a running balance
elaborate your question. Tim Whitley Wrote: Not sure is I completely undeerstand the question but my gusee is that the following would meet your need: =Sheet2!A1-Sheet1!A1 This assumes that the balance from the previous worksheet is still named Sheet1 and the balance that you need to deduct is in cell A1 from that page. It also assumes that you are subtracting the balance from cell A1 on Sheet2. Hope it helps. "johnilee" wrote: What I want to do is take the balance from a previous worksheet, in the same work book and subtract from that balance. Help!!! -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=533602 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
to keep a running balance
elaborate your question. Tim Whitley Wrote: Not sure is I completely undeerstand the question but my gusee is that the following would meet your need: =Sheet2!A1-Sheet1!A1 This assumes that the balance from the previous worksheet is still named Sheet1 and the balance that you need to deduct is in cell A1 from that page. It also assumes that you are subtracting the balance from cell A1 on Sheet2. Hope it helps. "johnilee" wrote: What I want to do is take the balance from a previous worksheet, in the same work book and subtract from that balance. Help!!! -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=533602 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| running balance in Excel | Excel Worksheet Functions | |||
| How do i set up a running balance on one row? | Excel Worksheet Functions | |||
| running balance in excel | Excel Worksheet Functions | |||
| How do I calculate a running balance? | Excel Worksheet Functions | |||
| how : check register running balance is a stationary cell | Excel Discussion (Misc queries) | |||
Linear Mode
