Excel VBA Automation Macros
Budget: $30 – $100 USD
I need a set of well-structured, fully commented VBA macros in Excel that takes repetitive, time-driven work off my plate. The core requirement is to persist values into a designated table according to specific time-based logic (for example: snapshot once per day). All data lives inside Excel sheets—no calls to external databases or APIs—so the code must read from, write to, and manage ranges within the same workbook.
Please make the solution easy to maintain: group related procedures in clearly named modules, avoid hard-coded values where possible, and add concise inline comments so I can make changes later.
Deliverables
• A test-ready Excel workbook containing the macros
• VBA modules exported separately (.bas files)
• A brief README outlining setup steps, configurable parameters, and the time-logic you implemented
I’ll sign off once the macros run without errors, populate the tables exactly on schedule, and remain responsive even as the workbook grows.
Attached are a detailed requirements document and the Excel file involved. Please read the requirements document before applying for this project.
Please make the solution easy to maintain: group related procedures in clearly named modules, avoid hard-coded values where possible, and add concise inline comments so I can make changes later.
Deliverables
• A test-ready Excel workbook containing the macros
• VBA modules exported separately (.bas files)
• A brief README outlining setup steps, configurable parameters, and the time-logic you implemented
I’ll sign off once the macros run without errors, populate the tables exactly on schedule, and remain responsive even as the workbook grows.
Attached are a detailed requirements document and the Excel file involved. Please read the requirements document before applying for this project.