Excel Macro-Based Inventory Management System

Project Title: Excel Macro-Based Inventory Management System for Diamond Trading Project Description: I am looking for an experienced Excel VBA (macro) developer to create a comprehensive inventory management system tailored for my diamond trading business. The system should be user-friendly, efficient, and capable of handling dynamic data with automated calculations. Key Requirements: 1. Modules: - Cash balance -Purchase and Sales records -Upcoming receivables and payables - 2. Automation Features: - Automated calculations for inventory updates based on parcel changes. - Dynamic addition and deletion of rows with real-time data updates. - Scrollable history for easy tracking of past transactions. - Backup and restore functionalities (preferably using JSON or similar lightweight format). - Editable/deletable rows with proper data validation. 3. Design & UI: - Professional layout with a gold and grey theme. - Gold headers with complementary fonts, grey background with black text. - Clean, minimalistic, and business-oriented aesthetics. 4. **Performance:** - Fast processing of large datasets. - Error handling to prevent data loss or corruption. Preferred Candidate: - Strong background in Excel VBA and advanced macro development. - Experience with inventory systems, especially in trading or B2B industries. - Good sense of UI/UX design within Excel for professional business applications. - Ability to deliver clean, well-documented code for easy future modifications. Timeline: - I am looking to have this project completed within 1 - 2 Weeks. Budget: - INR 5,000 - INR 15,000. How to Apply: Please share examples of similar Excel projects you’ve worked on, particularly inventory management systems. Highlight any relevant experience with automation, dynamic data handling, or trading-related applications. ---