I'm trying to create a simple inventory control spreadsheet consisting of 4
columns. Name, Transfer In, Transfer Out and Current Stock. I need to be
able to put entries in Transfer In, Transfer Out, hit a button and have the
Current Stock updated accordingly where Current Stock = Current stock -
Transfer Out + Transfer In and then autozero the Transfer Out and Transfer
In levels.

I have put a command button in for the transfer which just calculates (the
user would forget to hit F9 otherwise - lol) and have set autocalc off and
iterations to 1 - is there an easy way of zeroing the Transfer In and
Transfer Out columns as part of the formula in the Current Stock column?

Thanks

Mike