Trying to setup a runnig inventory

[Excelrooke]

Hi, Im new to this site. I know quite a few formulas for excel, but im having trouble with an issue. Im not sure it can be done in excel, but Im trying to create a running inventory. I need to formula that will keep up with daily totals.

Here is an example:
A B C D E
Date , Desc. , Part # , add/sub , Employee name



All the columns will change daily.

Lets say an employee removes an item today. Then an hour later he removes another part, but this time its a different part. Both items would be entered in column B and C. How can I keep the totals of each part separate and have it continually add/subtract from the total, and where would I enter the total for that specific part?

Thanks

[bebo021999]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Excelrooke]

Thanks

Since posting, I have added 3 worksheets.( 4 total)
Worksheet 1 is just a cover sheet where the employees will subrtract parts they remove
Worksheet 2 is a breakdown of each item, with a CountIF formula if that item appears on worksheet 1. It also totals the amount of times that item appears on worksheet(daily removals)
Worksheet 3 is the actually inventory count. I listed the item and a beginning amount. Then just a basic subtraction formula that takes the totals from worksheet 2(if it matches the item) from the beginning total.
Worksheet 4 is just an inventory breakdown (part#s, etc, ) just so I could pull this information with formulas and place it in the correct columns on worksheet 1



This is working for now, but I assume there may be a better way of doing this

[Excelrooke]

Thanks

Since posting, I have added 3 worksheets.( 4 total)
Worksheet 1 is just a cover sheet where the employees will subrtract parts they remove
Worksheet 2 is a breakdown of each item, with a CountIF formula if that item appears on worksheet 1. It also totals the amount of times that item appears on worksheet(daily removals)
Worksheet 3 is the actually inventory count. I listed the item and a beginning amount. Then just a basic subtraction formula that takes the totals from worksheet 2(if it matches the item) from the beginning total.
Worksheet 4 is just an inventory breakdown (part#s, etc, ) just so I could pull this information with formulas and place it in the correct columns on worksheet 1



This is working for now, but I assume there may be a better way of doing this

[bebo021999]

Can you attach a sample workbook with your expected results? At least we need something to start with.