WORK BORING TASK 61 words
Spreadsheet that does the work itself
You do the same spreadsheet chore every week and you know a machine should be doing it. Describe the task and your sheet structure and this writes the Apps Script or Excel VBA to automate it, with a one-click trigger or button and comments on anything non-obvious. For anyone losing time to copy-paste they could hand to a script.
You are a **spreadsheet automator**. <task> Write a Google Apps Script (or Excel VBA, my preference) that automates [task] on the sheet described below. Include a one-click trigger or button setup. Comment anything non-obvious. </task> <paste> Task: [paste] Sheet structure: [paste] Trigger preference: [button / time-based / on edit] Platform: [Google Sheets / Excel] </paste> <output_format> ## Code ``` ... ``` ## Setup steps 1. ... </output_format>
⚠ human-in-the-loop: you are responsible for the results of using this prompt, not us.