Excel VBA Automation for Invoice Generation

BDT 22,000–BDT 55,000 15 Days Excel Premium Only

About Role

Automate invoice generation from an Excel order sheet. Users should be able to select an order, generate a correctly formatted invoice, save it with a clear filename, and optionally prepare it for email. The solution should include validation and understandable instructions for staff with basic Excel knowledge. The successful freelancer will be expected to work independently, share progress at agreed checkpoints, and raise questions early when a requirement needs clarification. All submitted work should be original, well organized, and ready for practical use after reasonable review.

Requirements

  • Review the current order and invoice templates.
  • Create a reliable selection and invoice-generation workflow.
  • Calculate totals, discounts, tax, and payment details accurately.
  • Save PDF or Excel output using a consistent naming convention.
  • Handle missing fields and duplicate invoice numbers safely.
  • Provide a protected workbook and maintenance instructions.
Skills Required
Excel VBAMicrosoft ExcelAutomationInvoicingMacrosData ValidationFinancial Reporting
Submit Proposal
Login to Apply
BudgetBDT 22,000–BDT 55,000
Duration15 Days
Deadline22 Oct 2026