Inventory management

I need an Excel VBA to maintain in-out stock. I get material through delivery challan and same the material is dispatched on my challan. So i need traceability of stock along with all filter of date, part, challan, New/Rework.