stock control help
 

Hi
I need to keep track of some of our inventory, so i have a cloumn for the
items, one for stock on hand, one for taken amount and one for amount left -
i have another section a couple rows over for the items again, who has taken
them, what date and how many, is there a table that can be updated with these
fields, on a daily basis or do i need to do a new table for everyday to keep
up to date with the stock? as i need to keep track of all dates and amounts
of items taken, and not write over them everyday as my table would have me
doing at this stage.
Thanks

stock control help
 

Hi Sonia,
Why you don't use a userform, take a look to Debra Web she give an example
of Inventory control
http://contextures.com/xlUserForm01.html
Hope this help

"sonia" wrote:

Hi
I need to keep track of some of our inventory, so i have a cloumn for the
items, one for stock on hand, one for taken amount and one for amount left -
i have another section a couple rows over for the items again, who has taken
them, what date and how many, is there a table that can be updated with these
fields, on a daily basis or do i need to do a new table for everyday to keep
up to date with the stock? as i need to keep track of all dates and amounts
of items taken, and not write over them everyday as my table would have me
doing at this stage.
Thanks