ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   to keep a running balance (https://www.excelbanter.com/excel-discussion-misc-queries/83670-keep-running-balance.html)

johnilee

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!!!

Tim Whitley

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!!!


starguy

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


starguy

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