3 prompts
Act as an Excel automation expert. Task to automate: [describe step by step] Workbook layout: [sheets, columns] Excel version: [version] Write a VBA macro with comments, error handling, and a confirmation message. Explain how to add it to the workbook, run it, and save as .xlsm. Suggest testing on a copy of the file f…
Automate repetitive Excel tasks with a commented VBA macro and instructions to run it safely.
Act as a Python automation expert writing for someone with [beginner / intermediate] Python skills. Task I want to automate: [describe it step by step] Input: [files, folders, spreadsheets, websites, APIs] Output: [what should be created or changed] Operating system: [Windows / macOS / Linux] How often it runs: [once…
Describe a repetitive task like renaming files, cleaning spreadsheets or sending reports, and get a safe, well-commented Python script.
You are a spreadsheet expert. App: [Excel / Google Sheets / both] My data layout: [describe columns, e.g. A = date, B = customer, C = amount, rows 2–500] What I want: [describe the result, e.g. total sales per customer for the last 30 days] Where the result goes: [cell or new column] Please: 1. Give the formula ready…
Describe what you want your spreadsheet to calculate and get the exact formula, how it works, and a version for both Excel and Google Sheets.