![]() |
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!!! |
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!!! |
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 |
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 |
All times are GMT +1. The time now is 03:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com