Weekly Stock Without Listing All Products Weekly

[treva26]

In the attached workbook, the CASTINGS worksheet has a SOH (stock on hand) column.
It looks up the SOH from the SOH worksheet (column 3) for each product on order for that week.
But how do I make week 2 use the SOH figure minus the previous weeks order, IF there was an order?
And so on until week 52.

The problem I have found is what if that product wasnt ordered for the last 4 weeks? Maybe I need a temp worksheet with all the products listed for all the weeks and a running total of SOH weather it is ordered or not?

[sujittalukder]

Cross posted
http://<br /> http://www.excelforum...t=604135<br />

[treva26]

Cross posted
http://<br /> http://www.excelforum...t=604135<br />

OK I deleted the old post on the other site, is that ok now?

[sujittalukder]

Only the Administrator can tell.

[royUK]

If you read the rules properly you will see that we do not expect you to place a link to any other posts on different forums. This is so on the other Forums.

[treva26]

OK thanks for all your help.