Inventory Spreadsheet
 

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

Inventory Spreadsheet
 

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)
--
Best Regards,

Luke M


"Mike Langensiepen" wrote:

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

Inventory Spreadsheet
 

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!


"Luke M" wrote in message
...
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)
--
Best Regards,

Luke M


"Mike Langensiepen" wrote:

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