Excel macros are useful if you find yourself repeating the same actions time after time. When you create a macro, you record all the actions and commands you perform to complete a task. Then instead of repeating those actions you can simply run the macro. Doing this saves you time and reduces the probability of making mistakes.
There are two ways you can create a macro:
- Use the Macro editor
- Use the Excel macro recorder
Using the macro recorder is by far the easiest method, though you can create some quite complex macros with the macro editor. The problem with the macro editor is that it requires some technical expertise (otherwise known as programming!) to use it effectively.