Need Help with a Basic Inventory List with In/Out column

[Silvertooth]

Hi all. 

I need your help for a basic inventory count I have in work.

What I need to do is have the quantity of an item change by the amount entered in the in/out section (e.g. if somebody enters code M2 and then "-5" in the "In/Out" column, the quantity should decrease to 9.) 

Here is an example of what I have below. I have already created a drop down section for the Codes (There a many more rows, this is just a snippet.)

Code	Item	Quantity				Date	Code	In/Out	Psychologist
M1	BAI	32
M2	SCQ	14

Can anyone help me in going about to achieve this? A pre made excel would be even more appreciated.

[#2 · Accepted solution]

@Silvertooth 

I'm attaching one that I created a little over a year ago responding to another request here at the tech community forum. This workbook has a couple tabs and some commentary to describe how to use it. Basically, you begin with an "initialize" for each item in the activity log, and then as things come in or go out, they add to or subtract from that number and the current inventory is shown in the Inventory tab.

This workbook uses some of the most recently added functions in Excel, so you will need a current version installed.

[#3]

@mathetes  This solved my problem. Thank you so so much!