- Compare methods to create macros in Microsoft Excel
- Use a macro to remove duplicates
- Use a macro to select blank rows
In the workplace, people often find themselves completing repetitive tasks: completing the same calculations on different numbers, counting wins versus losses, etc. In Excel, you can create macros, programs that can automate these repetitive tasks.
Building a Macro
You can view the transcript for “Learn Excel MACROS in 10 Minutes Using Real World Examples” here (opens in new window).
Now, a Macro can be recorded to do anything. From this lesson we learned how to make macros that removed duplicates and blank rows.
You can view the transcript for “Quickly Remove Blanks and Duplicates in Microsoft Excel” here (opens in new window).