Adding Two Columns
 

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.

Adding Two Columns
 

surely you are using formulae? thats the point of Excel

in F8
=F7+E8

then copy the formula down the column

"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.

Adding Two Columns
 

In F2 type =F1+E2 and hit enter. Now copy this down the spreadsheet.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"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.

Adding Two Columns
 

The formula that I am using is roughly the same as everone is giving me.
However, I have to manually paste this formula into every "F" cell to get the
new total. I am looking for one general Catch-all to use, that will
automatically fill in a new total, after I type in my new transaction into
"E", without ever touching "F".

"Patrick Molloy" wrote:

surely you are using formulae? thats the point of Excel

in F8
=F7+E8

then copy the formula down the column

"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.

Adding Two Columns
 

ok, then i suggest using the worksheet's CHANGE event...


Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 Then
Target.Offset(, 1).FormulaR1C1 = "=R[-1]C + RC5"
End If
End Sub

"Gr8 Dane" wrote:

The formula that I am using is roughly the same as everone is giving me.
However, I have to manually paste this formula into every "F" cell to get the
new total. I am looking for one general Catch-all to use, that will
automatically fill in a new total, after I type in my new transaction into
"E", without ever touching "F".

"Patrick Molloy" wrote:

surely you are using formulae? thats the point of Excel

in F8
=F7+E8

then copy the formula down the column

"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.

Adding Two Columns
 

Hi
Which version of Excel are you using?

With XL2003 DataList
With XL2007 Insert tabTable

Both List and Table will automatically add formulae to each new row that you
add.

--
Regards
Roger Govier

"Gr8 Dane" wrote in message
...
The formula that I am using is roughly the same as everone is giving me.
However, I have to manually paste this formula into every "F" cell to get
the
new total. I am looking for one general Catch-all to use, that will
automatically fill in a new total, after I type in my new transaction into
"E", without ever touching "F".

"Patrick Molloy" wrote:

surely you are using formulae? thats the point of Excel

in F8
=F7+E8

then copy the formula down the column

"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.