I’m looking to roll out a single Excel workbook—driven entirely by VBA—that will let my warehouse team record every kilogram of finished product that enters or leaves our godown. Each transaction must be captured against party, purchase order, batch, and current process stage, then stored in one normalized table so we never touch raw data again. Key flow • A clean user-form (no sheet scrolling) for data entry, validating quantities and dates before they hit the table. • Automatic posting of in- and out-movements, with running balances calculated product-wise in the background. • A daily summary report that refreshes with one click (or on open), showing the running balance for every product. Non-technical staff should be able to read it without hunting for filters. • All file paths, pivot refreshes, and calculations handled in VBA so nothing breaks if the workbook is moved. • Code structured for future categories—raw materials or packaging—though the first release focuses only on finished products. Deliverables 1. Locked, production-ready macro-enabled workbook (.xlsm) with documented VBA modules. 2. User-form for transaction entry. 3. Daily summary sheet displaying running balance per product. 4. Quick-start guide (PDF or Word) so new staff can begin using the tool in minutes. 5. Up to one revision round after initial hand-off to fine-tune field names or formatting. Acceptance criteria • Entering a test batch and dispatch updates the running balance instantly with no manual formula edits. • The daily report regenerates in under five seconds on a standard office PC. • Moving the workbook to a different folder or PC does not produce path errors. If this sounds like something you can build robustly and cleanly, I’m ready to get started right away.