Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. Business details: - Company name: [your company name] - Currency: [USD/EUR/GBP/IDR/etc.] - Tax rate: [e.g., 11% PPN] - Payment terms: [e.g., Net 30] Build a workbook with: **Sheet 1 — Invoice Template:** - Professional invoice layout with company header - Auto-generated invoice number (format: INV-2026-0001) - Date and due date (auto-calculated from payment terms) - Client info section - Line items table (description, quantity, unit price, total) - Subtotal, tax, discount, grand total formulas - Payment instructions section - Notes/terms section **Sheet 2 — Invoice Log:** - Automatic log of all generated invoices - Columns: Invoice #, Date, Client, Amount, Status (Unpaid/Paid/Overdue) - Conditional formatting: Red for overdue, Green for paid - Summary: Total outstanding, Total paid this month **VBA Macros:** 1. `GenerateInvoice()` — Creates new invoice with next sequential number 2. `SaveAsPDF()` — Exports current invoice as PDF with invoice number as filename 3. `LogInvoice()` — Records invoice details to the log sheet 4. `MarkAsPaid()` — Updates invoice status in the log Provide all formulas and complete VBA code with comments.