J
johnilee
What I want to do is take the balance from a previous worksheet, in the same
work book and subtract from that balance. Help!!!
work book and subtract from that balance. Help!!!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tim Whitley
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.
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.
S
starguy
elaborate your question.
Tim said:Not sure is I completely undeerstand the question but my gusee is tha
the
following would meet your need:
=Sheet2!A1-Sheet1!A1
This assumes that the balance from the previous worksheet is stil
named
Sheet1 and the balance that you need to deduct is in cell A1 from tha
page.
It also assumes that you are subtracting the balance from cell A1 o
Sheet2.
Hope it helps.
S
starguy
elaborate your question.
Tim said:Not sure is I completely undeerstand the question but my gusee is tha
the
following would meet your need:
=Sheet2!A1-Sheet1!A1
This assumes that the balance from the previous worksheet is stil
named
Sheet1 and the balance that you need to deduct is in cell A1 from tha
page.
It also assumes that you are subtracting the balance from cell A1 o
Sheet2.
Hope it helps.