Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Inventory/Stock Control
Does anyone know of a free, simple inventory control spreadsheet/template.
All it needs to do is have a list of items (up to 100) with a stock on hand, transfer in and issue out option. Obviously, the transfer in and issue out out must update the stock on hand and then self zero. Any suggestions? Thanks Mike |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Inventory/Stock Control
Microsoft has plenty of templates for documents, worksheets, etc on its web
site. Several deal with inventory. "Mike Langensiepen" wrote: Does anyone know of a free, simple inventory control spreadsheet/template. All it needs to do is have a list of items (up to 100) with a stock on hand, transfer in and issue out option. Obviously, the transfer in and issue out out must update the stock on hand and then self zero. Any suggestions? Thanks Mike |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Inventory/Stock Control
The URL for the MS Template Gallery site is
http://officeupdate.microsoft.com/te...ry/default.asp Gord Dibben MS Excel MVP On Mon, 10 Dec 2007 08:13:01 -0800, Flick Olmsford wrote: Microsoft has plenty of templates for documents, worksheets, etc on its web site. Several deal with inventory. "Mike Langensiepen" wrote: Does anyone know of a free, simple inventory control spreadsheet/template. All it needs to do is have a list of items (up to 100) with a stock on hand, transfer in and issue out option. Obviously, the transfer in and issue out out must update the stock on hand and then self zero. Any suggestions? Thanks Mike |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Inventory/Stock Control
Thnaks for the suggestion but all the templates seem to do is act as a
simple record of inventory with no stock in/stock out functions. "Gord Dibben" <gorddibbATshawDOTca wrote in message ... The URL for the MS Template Gallery site is http://officeupdate.microsoft.com/te...ry/default.asp Gord Dibben MS Excel MVP On Mon, 10 Dec 2007 08:13:01 -0800, Flick Olmsford wrote: Microsoft has plenty of templates for documents, worksheets, etc on its web site. Several deal with inventory. "Mike Langensiepen" wrote: Does anyone know of a free, simple inventory control spreadsheet/template. All it needs to do is have a list of items (up to 100) with a stock on hand, transfer in and issue out option. Obviously, the transfer in and issue out out must update the stock on hand and then self zero. Any suggestions? Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INVENTORY STOCK COUNT | Excel Worksheet Functions | |||
inventory control | Excel Worksheet Functions | |||
Stock Inventory | New Users to Excel | |||
Inventory Control | Excel Discussion (Misc queries) | |||
A calculator for inventory safety stock | Excel Discussion (Misc queries) |