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!
