9 Replies Latest reply: Mar 14, 2014 9:24 AM by A B RSS

    Using loops in script

      Hi All,

       

      I have 2 tables with monthly costs and monthly income (pic1).

      I have a request to display monthly costs per items sold .

      For months which costs are not available, I have to use the last recorded cost.

      There can be few months missing.

      For example , for January 2014 and February 2014, I have to use the cost value from December 2013 (pic2).

      I was thinking of using For-Next loops and Peek to go over both tables and create the third.

      Is there a better alternative?

       

      Thanks!