calculating ageing of inventory base on months and weeks

[moein]

Hello every one!

recently we want to calculate the age of our stock base on days and weeks and months, here is our sample file

A1

Product Code​

Brands​

Product name​

Month1​

Month2​

Month3​

Month4​

Month5​

Month6​

Month7​

Month8​

Month9​

Month10​

Month11​

Month12​

Total buy-in​

total sales out​

current stock​

AGING OF STOCK​

920104058​

BAG​

BAG Green2​

0​

380​

0​

0​

450​

0​

0​

0​

0​

0​

300​

0​

1130​

687​

443​

68​

what im looking for is VBA witch get month number throw input then divide the current stock from input number month if its greater than month number then goes to one month back and caluculate again and at least show the age of the goods in inventory in another colums

this file have N row but for culums its fixed

will look forward to right answers,

 

[moein]

any help!