Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating balances
Please all help totally appreciated. I want to add values to another value in
another cell but want to see the values as they add up. E.g Cell G3 = E26+200+500 Gell G20 = 100 I want to add G20 to G3: Is it possible to leave the values as G3= E26+200+500+100 and even show the new value added of 100. THe code below just sums up the total without showing the breakdown of values added so far. With .Range("G3") .Value = .Value + ws.Range("G20").Value End With With .Range("G10") .Value = .Value + ws.Range("G21").Value End With Again is it possible to have G3 =E26+200+500+100 in G3 once code is executed. This way I see the values added not the whole added nos. This I need for G10 too when I add G21 value. Thanks so much for helping out. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Balances | Excel Discussion (Misc queries) | |||
Calculating Average Daily Balances | Excel Programming | |||
Showing zero balances | Excel Discussion (Misc queries) | |||
excel template for calculating trial balances and adjusting entri. | Excel Worksheet Functions | |||
How to link endings balances to beginning balances on different sh | Excel Worksheet Functions |