ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Inventory/Stock Control (https://www.excelbanter.com/new-users-excel/169036-inventory-stock-control.html)

Mike Langensiepen

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



Flick Olmsford

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




Gord Dibben

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





Mike Langensiepen

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








All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com