Advanced Excel VBA Inventory Management
Budget: $30 – $250 CAD
I require an experienced Excel and VBA specialist to help me create an advanced inventory management system.
Key Project Requirements:
- The system will include input forms for product entry, transactions, employees, locations, timestamps, and order numbers.
- It should also include the following KPIs: Stock turnover rate, Order accuracy rate, Backorder rate, and Inventory Accuracy.
- I'm looking for intuitive dashboards that can show these KPIs, stock levels and order details.
Specific Functionalities Needed:
- Data Validation: Ensuring accurate and clean data.
- Search Functionality: An easy way to search through the inventory.
- New Product Population (Kanban): Automatically adding new products.
- Picking Kanban Out: For efficient order fulfillment.
- Receive Kanban In: To easily record new stock.
This project requires a freelancer with a high level of expertise in Excel and VBA. Experience in inventory management or similar projects will be a big plus. Please reach out if you think you have the skills and experience for this task.
For reference I have attached my old Interface which i wish to expand using VBA and Macros
Key Project Requirements:
- The system will include input forms for product entry, transactions, employees, locations, timestamps, and order numbers.
- It should also include the following KPIs: Stock turnover rate, Order accuracy rate, Backorder rate, and Inventory Accuracy.
- I'm looking for intuitive dashboards that can show these KPIs, stock levels and order details.
Specific Functionalities Needed:
- Data Validation: Ensuring accurate and clean data.
- Search Functionality: An easy way to search through the inventory.
- New Product Population (Kanban): Automatically adding new products.
- Picking Kanban Out: For efficient order fulfillment.
- Receive Kanban In: To easily record new stock.
This project requires a freelancer with a high level of expertise in Excel and VBA. Experience in inventory management or similar projects will be a big plus. Please reach out if you think you have the skills and experience for this task.
For reference I have attached my old Interface which i wish to expand using VBA and Macros