Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Two Columns
In F2: =E2
in F3: =F2+E3 and fill it down as necessary! Regards, Stefi €˛Gr8 Dane€¯ ezt Ć*rta: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Two Columns
F3: =F2+E3
and copy down -- __________________________________ HTH Bob "Gr8 Dane" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding two Columns | Excel Discussion (Misc queries) | |||
Adding columns | Excel Discussion (Misc queries) | |||
Adding Columns, Then deleting old columns | Excel Discussion (Misc queries) | |||
adding columns | Excel Worksheet Functions | |||
Adding Columns | Excel Discussion (Misc queries) |