Forum Discussion
Need Help with a Basic Inventory List with In/Out column
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.
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.
- mathetes This solved my problem. Thank you so so much!
