Add Current Value to Previous Value of a Single Cell

  • Hi,

    I am exporting real time data into excel, and I would like to keep a running total of a single cell who's value is constantly changing. Lets say the values of this cell have read, 1, 3, 5, 2. I would like to be able to see another cell that is adding up these individual values and would read 11.

    Any help would be appreciated!

    Thanks!

  • Hi,


    A lot depends on how data is being imported into Excel ...

    For example the RTD function does not trigger any event ...

    If you are using RTD/DDE, you should try to use Application.OnTime Method (Excel)


    Meanwhile, you could test following event macro ... which displays the running total as well as the previous input :



    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!