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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

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

Similar Threads

Excel Sequential Numbering System 0
Inventory Tracking 2
Excel Changing amounts from one sheet to another using specific item # 7
Add/Subtract columns from tab to tab in same file 3
Access Scan a UPC on a txtfield on mainform & add to subform Please Help! 1
Using VBA to copy data into another worksheet ??? 2
Change worksheet direction from right to left 3
Oversensitive touchpad on modern laptops 0

Back
Top