Inventory Stock Reorder System

Project Title

Inventory Stock Reorder System – Excel Automation Dashboard

Project Overview

A practical Excel-based solution automating inventory monitoring, reorder filtering, conditional formatting, KPI insights, PDF generation, and email dispatch. This project simplifies stock management using macros and interactive dashboards.

Key Features

• 📊 Interactive Dashboard with Pivot Charts & Slicers

• ⚙️ Reusable Macro Automation (.bas export)

• 📥 Merge Excel files (2023 & 2024) into one Reorder sheet

• 📤 PDF Export of reorder list

• 📧 Automated Email via Outlook

• 📌 Navigation Panel with Macro Buttons
  
  

Tools Used

• Microsoft Excel (2016+)

• VBA (Visual Basic for Applications)

• Outlook (for email automation)

• GitHub (project hosting)
  
  

Key Insights

• Identified 595 reorder items out of 2,000 inventory lines

• Top suppliers requiring reorder:

  • Gulf Coast Traders (221)

  • Coastal Logistics Partners (212)

• Category with most reorder needs: Printer & Cleaning
  
  

Screenshots & Visuals

• 📷 Final Dashboard Image

• 📄 Sample PDF

• 🔁 Macro Button Panel
  
  

GitHub Repository

🔗 View on GitHub
Includes: 

• README.md 

• ApplyReorderLogic.bas: A reusable macro module so others can import it into their workbooks

• Inventory_Dashboard_2023_2024.xlsx: Final Excel file with merged data, dashboard, slicers, charts, and tested macros

• Reorder_Sample.pdf: Export sample of Filtered Reorder sheet 

• screenshots/dashboard_preview.png 

What I Learned

• Building end-to-end Excel automation with clean macros

• Using pivot charts and slicers for interactive insights

• Email integration with Outlook via VBA

• Dashboard design principles for business reporting

What’s Next?

• Web-based Streamlit version

• Dynamic Power BI or Tableau dashboards

• Multi-year trend analytics from warehouse data
  
  

✅ Call to Action – Let's Connect or Collaborate

📩 Have a similar challenge or project in mind?
I'm open to freelance opportunities, remote collaborations, or showcasing how I can help automate your Excel workflows and data processes.

📬 Get in touch:

• 📧 Email: dataexplorerconnects@gmail.com

• 💼 LinkedIn: Click here...

• 💻 GitHub: Click here..
  
  

🧠 Let’s turn your data into decisions.