I have just created and inventory management system using Excel. In this system, there is no macro. The sytem allows users to
- capture the details of the products in and out of the store or warehouse.
- prepare a report that will show the quantities left over in the store by products at the end of each month.
For more details, please read Inventory Management System.