Hi
I am just trying to make a stock register with tracebility.Want to track the materials on first in first out basis.I have one IN sheet and 2 OUT sheets where common materials from IN sheet
Hi
I am just trying to make a stock register with tracebility.Want to track the materials on first in first out basis.I have one IN sheet and 2 OUT sheets where common materials from IN sheet
I always hated homework like this because it is so basic as to be almost worthless.
As far as I can tell, you just need to link the cells and do some simple subtraction.
For instance, I believe that cell H3 should be:
=B3
and then copy that down using the quick-fill handle in the bottom right of the cell. For the balance, input =C3-G3-L3
into cell D3 and copy it down.
You should really look at these tutorials on Data Entry in Excel
That is what I would do but it seems too simple. If it doesn't work, then just ask your teacher for more guidance!