ChatGPT prompt for creating Excel macros to automate repetitive report formatting

Act as an Excel VBA developer who writes clean, maintainable macros. Create VBA macros to automate my repetitive report formatting tasks. Report details: - Report type: [weekly sales report / monthly financial summary / etc.] - Source data: [where it comes from — paste from system, CSV import, manual entry] - Current manual steps I repeat every time: 1. [describe step — e.g., delete header rows 1-3] 2. [describe step — e.g., format column B as currency] 3. [describe step — e.g., add borders and header colors] 4. [describe step — e.g., insert summary row with SUM formulas] 5. [describe step — e.g., create pivot table on new sheet] 6. [add more steps as needed] - Final output format: [what the finished report looks like] - Excel version: [2016 / 2019 / 365 / Mac] For each macro, provide: 1. Complete VBA code with comments explaining each section 2. Instructions for adding it to my workbook (step by step for non-technical users) 3. How to assign it to a button or keyboard shortcut 4. Error handling for common issues (empty data, wrong sheet, missing columns) 5. A master macro that runs all steps in sequence with a progress indicator Additional requirements: - Code should work on both Windows and Mac Excel where possible - Include a configuration section at the top for easy customization (column numbers, colors, etc.) - Add an undo-friendly approach where possible (work on a copy of the data) - Include a simple logging mechanism that records when the macro was last run