Forum Discussion
astandre85
Jul 27, 2022Copper Contributor
Need help finishing this inventory file
Hi- I've been working on creating an inventory log for my work. I manage a lot of spare keys, and they only get used if I have to replace broken keys on active sets, so I needed not only a physic...
mathetes
Jul 27, 2022Gold Contributor
I'm attaching a copy of an inventory spreadsheet I modified a little over a year ago for another poster here. It shows one way of handling almost exactly the same kind of in/out activity you're wanting to track. And it also uses SUMIF to update the actual inventory, much as mtarler has suggested (fortunately) in his prior post.
See if you can pick up on the method suggested there and make modifications to your own. And by all means come back and ask questions as needed.