Energy Drink Distribution

Well now let's take one of the many courses published in aulaclic.com which is recommended because, and here you will find excellent material.

When working with a personalized book that is, we have defined a number of specific characteristics may be the type font, the color of certain cells, formats and similar calculations, we lose a lot of time to format the entire book if you have many leaves.

macros With the aim is to automate several tasks and merge into one, adding such a button in our book that when you click on it to perform all these tasks.

The easy and intuitive way of creating macros is to create them using the macro recorder that is available to Excel.

This macro recorder lets you record the desired actions that subsequently translated into instructions in VBA, which can be changed later if have programming skills.

To record a macro must access the View tab and displays the Macros submenu in the submenu and select the Record Macro ...

addition to this option in the menu you can find the following options:

View Macros ... - Where access a list of macros created in that book.

Use relative references - With this option using Reactive references to macros are captured in action on the selected initial cell.

When you select Record Macro ..., the first thing you see is the Record Macro dialog box where you can give a name to the macro (not allowed to insert blank spaces in the name of the macro).

We assign a shortcut: Using the combination of CTRL + "key on the keyboard." The problem is to find a combination that does not already use Excel.

macro Under Save in: We can choose to store the macro in the active workbook in the personal macro workbook or another workbook.

In Description: we can describe what is the role the macro or any other information that we see fit.

To begin recording the macro press the OK button, and then if you look at the status bar, find the button in the status bar where we have the option to stop recording.

Since then we perform the actions you want to record, it is advisable not to select any cell from the recording, because if you select any cell then when you run the macro, the selection problems we can cause cells outside range.

Upon completion of the actions we want to record, pressed the Stop button in the status bar, or by accessing the Macros menu and clicking.