I am making a stock control spreadsheet, it is working well for the stock control but the order part is not working well, one of the sheets is a order form that has a macro to clear the sheet for a new order. I have three other sheets for the stock control.

I what to link the order sheet to the inventory out sheet that takes stock off the Stock sheet. Is there a way I can link the number ordered column to the quantity out column in the inventory out sheet with a formula that will allow the inventory out to work but won’t change the inventory back to the original number when I use the clear the order macro.
The 4 sheets i am using are:
Stock
inventory out
inventory in
Order

Thanks if you can help Jim