MACROS
Is used to repeat a set of action by pressing a set of keys.
Recording a Macro
1. Enable the Developer Tab. You can do this by going to the Advanced Option and checking the Developer Tab
2. Go to the Developer Tab and click Record Macro
3. Fill in the required details then click OK
4. You are now recording the Macro, do what the Macro should do.
5. When finished, click the Stop button at the status bar
6. Done! You just created a Macro
Reference:
http://brainchamber.com/wordpress/wp-content/uploads/2013/07/excel_marco1.png