Manufacturing Inventory Control.

[mawil1013]

Trying to do a 'simple' inventory control spread sheet.

Need to have a spot for, 'In Inventory'. Then need a spot to enter recently received chemical and/or a subtraction as chemical is removed for a production batch.

So I'll have the 'Chemical Name', then 'In Inventory', then a spot to add or subtract as chemical is received or chemical is used up in a production run.

Where can I find how to make a formula for this. I'd like a spot where it is blank, and as I add or subtract, after hitting enter, the spot clears and I can add or subtract again.

Michaelaw