How many times you repeated the same steps while creating some report in EXCEL?
It is for sure that such routines come in the way of each and everyone of us while working in Excel. For such situations, Excel provides us with an option called MACRO.
MACRO is a system of recording the steps which we have performed in Excel.
Suppose there are a number of steps in any calculation . For example, suppose we are given a task in which we need to do the following operations.
Firstly, adding the first and third cell, then subtracting the third cell from the fourth one, then adding the first with the four and so on.
The number of operations is big say 100.
Now if we have to repeat such operations twice or more than that and we start doing all those manually, we can imagine how much time it would take.
Or we can just create a MACRO, that is record all the operations and just click a button next time , and all the work is done with in a second.
So, MACRO is again one of the very important portion of the EXCEL.
In fact, MACRO is the front end of the VBA which is itself a complete programming language which allows us to do almost anything with our data.
In this article we’ll focus on the following.
The MACRO button is located under the VIEW TAB under MACROS section which is mostly to the extreme right of the ribbon.
MACROS CREATION is quite simple. Here are the steps for creating and Macros.
DESCRIPTION OF ANIMATED SCENARIO:
Use the following steps to run a MACRO
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE