Stock Control Spreadsheet needed

J

jaynew

Does anyone have any ideas of how I can create a stock control
spreadsheet in Excel? I am tasked to create one for printer toners to
control consumption.

What I need is to always know the levels, consumption per machine,
changes in consumption, low levels, re-order levels and common [shared]
stock.

If anyone has a quick solution - I would be very grateful.

Thanks a lot
 
A

andy edwards

oops, posted the last reply too quickly.

start access and run the database wizard, then choose
inventory control from the available templates - it has
all you need plus a few things you probably don't!
 
Top