What is a macro?
A macro is a series of instructions that you, as a user, can automatically direct Excel to execute upon the push of a button.
It saves time and is very helpful if you take the same steps with various reports in Excel.
These instructions can be saved to your personal macro workbooks in Excel to use whenever needed.
Automating Actions with Macros
Step 1: Ensure the Developer Tab is visible by going to File>Options>Customize Ribbon.
Step 2: Select Developer Tab, then select Record Macro.
Step 3: On the following screen, enter the Macro name at a minimum, then click OK.
It is recommended to store macros in the Personal Macro Workbook.
Step 4: Insert Instructions
For this example, the following instructions will take place
- Specific Text entered into G2
- CONCAT Formula inserted
- Hide excess rows
- Name column will be sorted
Step 5: Return to the Developer Tab and select Stop Recording.
The macro is now saved.
Running a Saved Macro
To run your saved macro, select the Developer Tab>Macros as shown below.
Search for the macro and click Run.
This will repeat all the steps you recorded as instructions for any sheet.
Video with Example
Take a look at this video with a similar example using the same table.