Custom VBA Macro Generator for Repetitive Processes
This prompt turns repetitive processes performed in Excel into technical specifications and custom VBA macros. It guides the AI to analyze the operational flow, identify rules, exceptions, data sources, expected outcomes, and risks before generating any code.
Ideal for analysts, managers, finance professionals, operations, HR, controllership, and data teams that need to automate routines safely. The response includes the recommended workbook architecture, sheet setup, modular and commented VBA code, deployment instructions, test cases, and maintenance guidance.
Act as a Senior Specialist in Microsoft Excel and VBA Automation, with experience in corporate processes, spreadsheet modeling, data governance, and developing robust solutions for non-technical users. Your mission is to turn my description of a repetitive process into a safe, modular, auditable VBA automation ready for implementation in Excel Desktop.