ANSWER 1 :
Macro Benefits
Macros offer many advantages to those who choose to use them. They reduce the possibility of human error that increases with many, repetitive keystrokes and tasks. Macros reduce the amount of time that must be spent performing basic computing tasks, freeing users up for more complex problem-solving and idea-generating activities. They also make complex computations easier to perform.

Using Macros
One of the benefits of macros is that they are easy to create, store and use. Macros record your keystrokes while you work. You can even assign a keyboard button to a macro so that common functions like formatting cells for text, adding formulas to spreadsheets, assigning rows to a target and formatting information into matched columns and rows.

Editing Macros
Making changes to a macro is as easy as setting one up. Macros aren't static. Once you record them, you can easily alter them to more effectively suit your needs. After you record a macro, you can view, change and correct errors in the code Microsoft wrote for it in Microsoft's Visual Basic Editor. Microsoft offers plenty of in-program help to guide beginners through the process of macro code editing. You'll quickly learn how to copy macros from one spreadsheet to another, share macros between workbooks with multiple users and much more. http://ask.brothersoft.com/what-are-the-advantages-of-excel-macros-197305.html
ANSWER 2: T he steps are follows :
1
Make sure you know how to perform each action you want and where to find all the menu options you need to select so you don't have to search for them while recording.
2
Find the macros menu and select the option to record a macro.
3
Name the macro.
4
Perform the actions you want the macro to perform automatically for you.
5
Stop recording.
6
Test the macro by using the keystrokes you assigned