Using loops in script

[#1]

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!

[#2]

Thank you all!

I find the references very useful too!