Macro in Excel is an incredibly valuable function that allows us to automate numerous repetitious tasks. Once a Macro is made, you can execute it as many times you want and whenever you want. This saves our time while minimizing some repetitive acts.
Below are the steps you must to follow to create a Macro
As you can
record any task that you conduct often, here I am assuming an example of
conditional formatting. Apparently, we continually verify for duplicate data in
your report. In order to do so, you have to go to Conditional Formatting Tab
>> Highlight Cell Rules >> Duplicate Values >> then you need
to select which colour you want to have for duplicate entries >> once you
are done, all the duplicate date will get highlighted
Ok Now we will automate try function.
1. Go to the View tab in the menu bar and click on Record Macro (Refer to the below screenshot)
2. Once you click on that, a new window will be opened, Enter Macro Name and pick Shortcut key, enter a description if needed. In the above example, we will enter the Macro name as DuplicateEntry and Shortcut key as Ctrl + n (Refer to the below screenshot) Press OK.
3. Right after you press OK, start performing the action that you want to automate. So in this case, we will start doing conditional formatting for the row already selected. Once done, go to the View Tab and click on Macros >>Stop Recording. (Refer to the below screenshot)
4. Macro is prepared now. Run a trial right away. Select another row and press the shortcut you entered. In our case, we have added Ctrl + n. So whenever we will press Ctrl + n, it will underline all the duplicate entries.
Comments
Post a Comment