Excel 2007 : New Inventory List

[danieledd]

Dear All,

I am new working with excel and I need help to create an inventory list wich updates the curent inventory and year to date total products manufactured. I have an Excel 2007
Assume the following:
I have an inventory list of 100 items listed in column C. Each item varies in quantity starting as a balance forward (original inventory).
Example: Item number 5, there are 56 pieces in stock (balance forward) which is listed in E5 and for item number 6, there are 48 pieces in stock (balance forward) which is listed in E6 and so on to the end of the list...

In column C5 I have the following item description: Soap Bar Lime 6oz
In column E5 I have the existing previous inventory quantity listed in number of pieces eg. 56
In column F5 I enter/add the new products manufactured in number of pieces eg. 44
In column G5 I enter/subtract the quantity sold in number of pieces eg. 22
In column H5 I need to get the updated quantity of inventory which in this case would be 78

In column J, I need to get the year to date products manufactured for each product which was entered in column F row... and added each time a new product was manufactured eg. 326 (pieces of soap)
I need to keep these 2 running balances on column H (curent inventory) and in column J (year to date manufactured) while I can put new/fresh data in columns F and G.
So after I make a new entry in any cell in columns F and G and I hit enter, the cell should clear out and leave room for my next entry.
In column K, I need to get the year to date sold fo each row eg. cell K5 is 248 (pieces of soap) .

I am attaching the worksheet which is not working yet... Any help would be appreciated.

Thank You