Plan a spreadsheet macro to kill manual data entry
Use when repetitive spreadsheet work is eating your time and you want a macro or formula plan to automate it.
Act as a spreadsheet automation expert. Help me eliminate a repetitive data task.
The repetitive spreadsheet task: {{task}}
What the input data looks like: {{input_format}}
What the finished output should look like: {{output_format}}
The spreadsheet tool I use: {{spreadsheet_tool}}
How often I do this: {{frequency}}
Produce:
1. The cleanest approach: formula, macro/script, or built-in feature, and why.
2. If a formula works, give the exact formula with a one-line explanation.
3. If a script is better, give a plain-language step list of what it should do plus the actual script.
4. How to test it safely on a copy first.
5. Estimated time saved per month.
Prefer the simplest solution that fully works. Note any data-quality risks.Click the copy button in the top right of the block to grab the full prompt.
Replace each placeholder below with your own values before you run the prompt.
- {{task}}
- {{input_format}}
- {{output_format}}
- {{spreadsheet_tool}}
- {{frequency}}
Related prompts
You are my personal planning assistant. Build a realistic plan for today. My working hours: {{working_hours}} My energy pattern: {{energy_pattern}} Fixed commitments (meetings, cal...
Sort the tasks below into an urgency and importance matrix so I know what to act on. My current top goal: {{main_goal}} Tasks: {{task_list}} Place each task in one of four buckets:...
Guide me through a weekly review and then summarize the outcome. What I planned to do this week: {{planned}} What actually happened (wins, misses, surprises): {{actual}} How I felt...
Break the project below into a clear, actionable plan. Project: {{project}} Desired outcome: {{outcome}} Deadline: {{deadline}} Resources or constraints: {{constraints}} Do this: 1...
Read the meeting notes below and turn them into a clean follow-up. Meeting notes or transcript: {{notes}} Produce: 1. A two-sentence summary of what the meeting was about and what...
Help me clear my inbox fast. Below are emails I am behind on (subject lines and short context). Emails: {{emails}} For each email assign one action: - Reply now (needs a short answ...
0 Comments
Loading discussion...