BestPromptFinder

Excel VBA Macro for a Repetitive Job

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

Write an Excel VBA macro to save me from a boring task I do by hand. The task, step by step as I do it now: [e.g. copy data from 12 monthly sheets into one summary sheet / split one sheet into separate files by region / format a raw export: delete blank rows, set column widths, add totals] My workbook: sheet names [ ], columns [ ], typical row count [ ] Excel version: [Microsoft 365 / 2019 / Mac] Please: 1. Write the complete macro with comments, with sheet and column names as constants at the top. 2. Make it work on a copy: it should save a backup or work in a new sheet/file, never overwrite the original data. 3. Handle missing sheets or empty data with a clear message box. 4. Explain step by step how to add it (Developer tab, Insert Module), run it, assign it to a button, and save as .xlsm. 5. Mention any part that won't work on Mac Excel. Keep it readable; no clever one-liners.

Why this prompt

• Hand-picked, editorially reviewed prompt
• Written for ChatGPT, Claude, Gemini

Source

Created by BestPromptFinder — editorial prompt, not user-generated. See our content & source policy.

Related Coding prompts