In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Excel VBA or Google Apps Script for a Repetitive Task
Prompt
Platform: {{PLATFORM}}
The task done by hand today, step by step: {{MANUAL_STEPS}}
Workbook layout (sheet names, header row, key columns, approximate row count): {{WORKBOOK_LAYOUT}}
Who will run it and how often: {{USER_AND_FREQUENCY}}
Write the script. Rules:
- Show only what is needed for the task; no feature extras.
- Work on a copy: the script must not overwrite source data, and writes results to a new sheet or clearly marked columns.
- Read ranges into an array and write back once, not cell by cell, for speed.
- Include simple error handling and a message that says what the script did.
- Comment each block.
Output: the code, steps to install and run it (where to paste it, how to enable macros or authorise a script), a safety checklist (back up the file, test on a dummy copy, review the code before you run it), and what I should check afterwards. Warn me that macros and scripts can change or delete data and that I should never run code I don't understand. If the task could be done with a built-in feature instead, say so.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Excel VBA or Google Apps Script for a Repetitive Task” is a free prompt for ChatGPT in the Coding & Software category, 196 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{PLATFORM}}, {{MANUAL_STEPS}}, {{WORKBOOK_LAYOUT}}, {{USER_AND_FREQUENCY}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 10 times.
Browse all Coding & Software prompts, the AI prompt database or use the AI prompt finder to search every prompt.