On Feb 10, 2:59*am, Gr8 Dane
wrote:
Ok. Thank you all for your replies. It looks like I'll be copying the Formula
and pasting it into every cell in "F" as well, unless I'm misunderstanding
something. It does add the current "E" into a new total, but i still have to
manually paste the formula into each "F" cell to get the new total. At least
I dont have to do the math too.

"Lynz" wrote:
Gr8 Dane wrote:
I have an open workbook with mulitiple sheets. I want to create a column "F"
that will keep track of all transactions made in column "E". e.g
* * *"E" * * * * * * * * *"F"
Amount $ * * * * * * Balance
$5,000.00 * * * * * $5,000.00
-$0.04 * * * * * * *$4,999.96
$3.89 * * * $5,003.85
$24,000.00 * * *$29,003.85
$21,000.00 * * *$50,003.85
$16,000.00 * * *$66,003.85

However, as of right now, I have to manually add/subtract "E" and then type
it in to "F". What can I do to have this done automatically? I am falling way
behind in doing this manually and need to catch up/remain current on 50+
pages, and counting.

Try putting this in F2 =Sum($E$2:E2) and copy down. *Formula in F3 will
be =Sum($E$2:E3) etc. Is that what you wanted?
Hope that helps.

No you don't, just paste the code into the workbook module, then when
you place a new number in column E the total will change in Column F