Stock Count Sheet

See the workbook I've posted. I changed your Qty column on sheet2 to hold the original qty, and then created a new column to hold the remaining qty. Will this work for your purposes?

If you'd prefer to change the Qty column instead, you'll probably want to use a macro. You'll need something to trigger the macro to run. How would data be entered into sheet 3?