|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 20th, 2007, 04:52 AM
posted to microsoft.public.excel.setup
|
|||
|
|||
How do I set up an inventory control worksheet to show items left
I want to set up a worksheet that will show items on hand and give a running
total as items are used. 
|
|
#2
July 26th, 2007, 05:52 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
How do I set up an inventory control worksheet to show items left
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
