Generate a VBA Macro for Repetitive Workpaper Tasks

What You'll Get

Working VBA code you can paste into Excel's Developer module — automating a repetitive formatting or data task across your workpaper without any programming knowledge.

The Prompt

Write a VBA macro for Excel that does the following: [describe exactly what you want it to do, step by step, as if explaining to someone who doesn't know Excel. Include what triggers it, what it loops through, and what the end result should look like].

Tips

Always test the macro on a copy of your workpaper before running it on the original — never on the live file. Describe the task step-by-step as if explaining to someone who doesn't know Excel; the more specific you are, the less debugging you'll need.