Excel VBA Inventory & Sales Tracker

This is an *Excel VBA-based inventory and sales tracking system* designed to automate order processing, inventory updates, and cost calculations. The system includes:

- **Sales Entry Form** (UserForm) for recording orders.
- **Inventory Management** with FIFO-based cost calculations.
- **Product Bundles** that deduct individual item stock when sold.
- **Multiple Sales Channels** with separate tracking sheets.
- **Automated Stock Updates** when sales are recorded.
- **A Dashboard** (to be developed) for sales insights and inventory status.

The project is 90% complete but has a few remaining issues that need to be addressed:

✅ **Fix Type Mismatch Errors** that prevent successful order saving.
✅ **Correct Inventory Deduction Logic**, ensuring FIFO principles are followed.
✅ **Ensure Bundle Items Are Deducted Properly** when a bundle is sold.
✅ **Prevent Incorrect Inventory Deduction** if an error occurs.
✅ **Develop a Dashboard** for tracking sales, stock levels, and profitability.
and a possible translation to a web-based app or Android app.

**Freelancer Requirements**
- **Expert in Excel VBA**, with experience in **inventory management systems**.
- **Strong debugging skills** for fixing type mismatches and logic errors.
- **Understanding of FIFO-based stock tracking**.
- **Experience in creating Excel Dashboards** with real-time updates.
- **Ability to optimize and clean up existing VBA code**.
-**Expert in Android app or web app creation.

? **The project is nearly complete—just needs debugging, minor fixes, and dashboard creation.
Details provided to the candidate selected.