So, either way I do this, I will still have to type something into "F",
whatever the formula? I can't just type in the new transaction into "E" and
be done?

"Pecoflyer" wrote:


Gr8 Dane;222593 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.

Something like: enter in f12 =f11+e12 and pull down as needed

If you want cells to stay empty if there is no value in col E :
if(e12="","",f11+e12) and also pull down as needed


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload -faster and better answers

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61491