I have two cells in excel sheet
The first cell (let's say cell number C7) , I'll paste a numeric value on it, every several seconds. That's mean the new value will overwride the old value of the cell.
The second cell (let's say cell number C8), It should automatically show the average value of all values that pasted in cell number C7.
How could I calculate this average value? Please.
I had some knowledge in VBA.
(maybe I need to create an array to hold all C7 values, so I can display the average every time!)
please describe the events I should use, and how to go to code page in excel.
thanks in advance.