Is it possible to programme excel to watch one cell for ten times and then give you the total or to copy the totals to other cells for ten totals and then give you a running total
Is it possible to programme excel to watch one cell for ten times and then give you the total or to copy the totals to other cells for ten totals and then give you a running total
Hi,
Your question is rather mysterious ...
Are you looking for
HTH=sum($A$1:A1)
Carim
HI Carim
Not quite, Simular Idea but the cell must show the aqumulated Total
the Idea is a person is training and is using x amount of energy for 1 hr and he does 10 different exercises and the total must show at the end but I dont want to show all the results
Well, since I do not know how your worksheet is structured ...
It is quite difficult to give you a precise answer ...
Below is an event macro with is self cumulative ...
Select any cell, type any numbers in that cell, the cell to its left will always show the updated "cumulative total" ...
Go to worksheet tab, right click, select view code, and copy code ...Private Sub Worksheet_Change(ByVal Target As Range) Dim OldVal As Variant, NewVal As Variant If Target.Count > 1 Then Exit Sub Application.EnableEvents = False NewVal = Target.Value Application.Undo OldVal = Target.Value If IsNumeric(OldVal) And IsNumeric(NewVal) Then Target.Offset(0, 1).Value = NewVal + Target.Offset(0, 1).Value End If Target.Value = NewVal Application.EnableEvents = True End Sub
HTH
Carim
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks