How to use
After demonstrating the process, click Finish and Convert. Review the generated code/steps and test the result on a copy before using it. Check the result before saving changes.
Assist Pro / Macro Wizard
Finish and Convert
Converts a recorded procedure into a reusable macro.
Where to find it
Follow the ribbon path.
Assist Pro → Macro Wizard → Finish and Convert
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
Converting recorded steps into a reusable macro.
Everyday Excel
Removes repeated manual spreadsheet workflows when you need to convert a recorded procedure into a reusable macro.
Accounting and audit
Automates repeated audit-data preparation workflows by helping convert a recorded procedure into a reusable macro.