Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to perform cumulative addition in excel V6=V6+T6
I want to ask how to initialize a cell with a value and also I want to
perform calculation like..the previous value gets added to current value.. like I have value in cell T6=23 initially V6=0 now V6=V6 + T6 ie V6= 23 Now I want to change T6=20 So the Value of V6 now becomes = 43 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to perform cumulative addition in excel V6=V6+T6
Sadhana,
You can do it using the change event. Copy the code below, right-click the sheet tab, select "View Code" and paste the code into the window that appears. HTH, Bernie MS Excel MVP Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$T$6" Then Exit Sub Application.EnableEvents = False Range("V6").Value = Range("V6").Value + Target.Value Application.EnableEvents = True End Sub "Sadhana" wrote in message ... I want to ask how to initialize a cell with a value and also I want to perform calculation like..the previous value gets added to current value.. like I have value in cell T6=23 initially V6=0 now V6=V6 + T6 ie V6= 23 Now I want to change T6=20 So the Value of V6 now becomes = 43 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
How do I perform an IF function on Microsoft excel? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
CAN I INSTALL EXCEL ON MY XP HOME ADDITION LAPTOP ? | Excel Discussion (Misc queries) |