How do I set up an inventory control worksheet to show items left

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leonard - 20 Jul 2007 04:52 GMT

I want to set up a worksheet that will show items on hand and give a running
total as items are used.

Reply to this Message

Clark - 26 Jul 2007 17:52 GMT

A typical sheet would be Colum A for Part/Item #, Colum B starting inventory,
Colum C current inventory, and Colum D Total used. Colums after D would be
each daily bucket. lets assume the total number of colums are 30 (one for
each day of the month) meaning the colum E is for day 1 and colum AH for day
30.

formulas to enter in cell D1 could be "=sum(c1:ah1) would give the total
used for the 30 day period. For the current inventory would be "=b1-d1" in
cell C1 to give on hand balance. Be sure to enter the formula in D1 first or
the formula in c1 will not be correct.

Does this help?

Signature

Clark

> I want to set up a worksheet that will show items on hand and give a running
> total as items are used.

Reply to this Message