Hi there,
I'm trying to create an inventory table on our stock.
Everyday there will be inventory produced and delivered out.
eg.
A1 to A10 is incoming stock
B1 to B10 is outgoing stock
C1 to C10 is Stock remaining.
(A1-B1=C1, C2=C1+A2-B2 etc....)
The problem is that my inventory has cure time before sending out. Let's say, I have a cell which I can key in like '5' days cure time, the Stock remaining at C10 will minus away those produced in the last 5 days (incoming) meaning from B10,B9,B8,B7,B6 and the results at Row 10 which is where the stock remaining is will change accordingly to what I keyed in which in this example is '5'.
How do I link formulas up?
Bookmarks