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

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?
--
Clark


"Leonard" wrote:

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