VBA+ Macro Based Inventory Management

Description:

I need a professional to design a custom, user-friendly Excel-based Inventory & Ledger Management System with the following key features:

Key Features:

Dashboard with buttons for:

Purchases (requirement list creation)

Receiving (updating received items against requirements)

Transfers

Waste

Staff Food

Closing Stock

Assets Inventory (separate data section)

Sub-categories for all items with UOM dropdown for accurate unit selection and automatic conversion to standard UOM.

Manage cash ledger and supplier ledgers, including setting opening balances and purchase entries.

Store detailed supplier invoice data (date, purchase details, VAT, credits).

Easy export to Excel in my approved format (ready for Tally upload).

Track asset inventory separately.

Functionality to send requirement lists and update receiving data when goods are delivered.

Clean, professional interface designed for non-technical users.

Deliverables:

Fully functional Excel tool with VBA/macros for automation.

Well-structured backend data tables.

Easy-to-use buttons and forms for all functions.

Export-ready templates for accounting integration.

If you can deliver a smooth, professional solution meeting these requirements, please share:

Examples of similar projects you have done

Your best quote and timeline