running total

[pradeep kalele]

Dear sir,

I want to feed cell A1 daily and it should change the total of cell B1. Kindly help. Thanks,

Pradeep Kalele

 

[pradeep kalele]

In cell B1, have put formula =B1+A1. This shows '0' in cell B1, even if there is '1' in cell A1

 

[xlstime]

Hi Pradeep,

Can you please explain your query little more, do you want to update same cell (A1) every day and do you want to cumulative in cell B1.

Than there is no way to achieve this with this. you have to maintain historical data or use VBA but VBA is also will not be able to help you, because in the worksheet event there is on event call "SelectionChange" you can use this but if just go to A1 and back to another cell this will sum up with on B1

Dear sir,

I want to feed cell A1 daily and it should change the total of cell B1. Kindly help. Thanks,

Pradeep Kalele

 

[pradeep kalele]

Hi Pradeep,

Can you please explain your query little more, do you want to update same cell (A1) every day and do you want to cumulative in cell B1.

Than there is no way to achieve this with this. you have to maintain historical data or use VBA but VBA is also will not be able to help you, because in the worksheet event there is on event call "SelectionChange" you can use this but if just go to A1 and back to another cell this will sum up with on B1

Yes you got it right. A1 will be updated every day and the cumulative should be in the B1. I am disappointed to hear from you (the heros of Excel) that there is no way. There must be some way, please reveal this.

 

[John Jairo V]

Hi @pradeep kalele

Check the file with Event Change into Sheet. If you change the value of A1, into B1 see the cummulative sum.

Private Sub Worksheet_Change(ByVal Target As Range)
    Application.EnableEvents = 0
    If Target.Address = "$A$1" Then [B1] = [B1] + [A1]
    Application.EnableEvents = 1
End Sub

Blessings!