How to use
Choose Create Macro, describe the task with the sheet/column layout, and review the generated steps or code. Test on a backup workbook before saving or reusing. Check the result before saving changes.
Assist Pro / Macro Wizard
Create Macro
Opens Macro Wizard to generate a VBA macro from a written instruction.
Where to find it
Follow the ribbon path.
Assist Pro → Macro Wizard → Create Macro
Included in Assist Pro.
Open the tool and follow its prompts. Use a copy of your workbook when trying an action for the first time, then check the result.
Browse all toolsPractical guidance
Use this tool in your workflow.
Best use case
Generating a repeatable macro from a written instruction.
Everyday Excel
Removes repeated manual spreadsheet workflows when you need to open Macro Wizard to generate a VBA macro from a written instruction.
Accounting and audit
Automates repeated audit-data preparation workflows by helping open Macro Wizard to generate a VBA macro from a written instruction.