"marabona" wrote in message
...
This is just a P+L for internal purposes, therefore general accounting
principles do not matter. If someone could answer with formulae it would
be
much appreciated


Well just do what I said - have a cell on the P&L sheet that says no of
units sold. On another sheet in the same workbook, you have your opening
stock in one cell, the amount sold in another cell, (data from the P&L
sheet), and a Stock remaining cell. (Opening - sold). Then in another cell
you say "if the Total remaining is LESS than a certain number, do the
re-ordering process".

I'm sure someone of your calibre can work out the formula from that - if you
can't then I suggest you find someone locally to help you...