Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inventory/Stock Control | New Users to Excel | |||
stock control | Excel Discussion (Misc queries) | |||
How do I set up a stock control template? | Excel Worksheet Functions | |||
stock control spreadsheet | Excel Worksheet Functions | |||
Stock control..help please | Excel Discussion (Misc queries) |