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

G

Guest

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

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top