A macro is a set of instructions that tells Microsoft Excel (or another application) to perform
one or more actions for you.
Macros are like computer programs, but they run completely
within Excel.
You can use them to automate tedious or frequently repeated tasks.
Macros can carry out sequences of actions much more quickly than you could yourself.
Macros can be simple or extremely complex. They can also be interactive; that is, you
can write macros that request information from the user and then act on that information.
There are two ways to create a macro: You can record it, or you can build it by entering
instructions in a module. Either way, your instructions are encoded in the programming
language Microsoft Visual Basic for Applications (VBA).
Here you will first learn how to record and execute a simple macro. Then you’ll learn
how to view the recorded macro and make it more useful by doing some simple editing.