Excel Inventory Control System DEMO
This video shows an Inventory Control System that was built in Excel. The purpose is to demo the various layers to consider in creating such a document:
– Distinct Incoming, Outgoing and Inventory Sections
– Required fields so that complete info is entered
– Alerts that give users an idea of anything that’s missing
– Protected cells so that formulas can’t be accidentally corrupted
– Prevention against a user requesting something that isn’t in inventory
– Prevention against a user requesting more than what is in inventory
– Use of dependent drop lists to control input and output
I don’t go into the “how-to” but if anyone is interested, please let me know.
NOTE: Several people have contacted me about this document.
I’ve made it available for download at a low price at http://datascopic.net/downloads/inventory/