6 Replies Latest reply: Feb 7, 2014 4:10 AM by Frank Hartmann RSS

    moving average

    Frank Hartmann

      Hallo QV Community


      I use the following formula in the chart for accounting the moving average:







      Is there any possibility to export the last value (=9) of the Rangesum formula to a textbox?

      I tried to use the Rangesum formula within a textbox but it doesnt work for specific month.


      The reason why i want to get this value to a textbox is because i need the value exported per macro to a powerpoint

      document as picture or  as object.


      any ideas?


      thanks for your help