What is a MACRO?
A macro is a recording of a set of steps that you can run as many times as you want. When you create a macro, you are recording your mouse clicks and keystrokes. After you create a macro, you can edit it to make minor changes to the way it works, and create buttons and shortcuts to run it.
Follow along with this spreadsheet. It is the one used to record two macros.