calculate opening stock and closing stock using loop

[#1]

hi,

i have data which is moth wise as well as model wise ...i have opening stock of the first month,now i want to calculate the stock received and the closing stock of the first and next 11 months,also the forecast opening stock from next month  ....also previous months closing stock will b the next months opening stock i.e closing stock(April)=opening stock(May)  and i want to calculate opening stock ,stock received as well as closing stock for 12 months....here i need loop....

Given:Opening Stock of the first month

achieve: Stock received and closing stock of the first Month

             forecast opening Stock, Stock received and closing stock from the next month .

i have attached the sample data...

plz help me..thanks in advanced

[amayuresh]

How are you referring enclose tab to do your calculation ?

Please explain your requirement in brief with example using enclosed excel file.