Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 18
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 46
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 18
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
INVENTORY STOCK COUNT vandy Excel Worksheet Functions 7 December 15th 06 01:20 AM
inventory control TRIMCO Excel Worksheet Functions 0 October 13th 06 05:16 PM
Stock Inventory larry_saudi New Users to Excel 2 July 18th 06 05:56 PM
Inventory Control WLMPilot Excel Discussion (Misc queries) 2 May 16th 06 12:30 AM
A calculator for inventory safety stock Angelus Excel Discussion (Misc queries) 0 May 10th 06 08:04 AM


All times are GMT +1. The time now is 08:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"