Inventory Spreadsheet

[Mike Langensiepen]

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

 

[Luke M]

At the end of the macro you wrote for the command button, just write (or
record) some coding deleting the contents of columns Transfer In and Transfer
out (except for the headers, of course)

 

[Mike Langensiepen]

Thanks for the reply - I figured it out after recording a macro and looking
up some associated commands. It's working quite nicely now but I was
surprised that no similarly coded examples were available off the Microsoft
Templates site as it seems like a gross ommission!