Macros sprint to finish a task before you can blink.
Macros can help you streamline your productivity. Just think of those repetitive steps that you wish you had a button to push to get it done. Well, it is possible to some degree. Macros can speed up those common functions like copying and pasting information somewhere else within the workbook, and retyping the same information over and over again. You can even create a macro to take you to another place within the workbook after you finish a certain task. Becoming macro happy is easier than you think.
Instructions
1. Open Excel and then click "Macro Security" in the code group under the developer tab. If the developer tab is not shown, click the Microsoft Office Button, and then click "Excel Options." Select the "Popular" category under "Top Options for Working with Excel," check "Show Developer tab in the Ribbon" and then click "OK."
2. Click "Enable all macros (not recommended, potentially dangerous code can run)" and then click "OK."
3. Click "Record Macro" from the code group.
4. Type in a short, descriptive name in the "Macro name" box, and then assign a shortcut key, if desired. Using spaces or names of cell references are invalid. The macro name must start with a letter.
5. Select where to store the macro from the "Store macro in" drop-down list box. Options include "Personal Macro Workbook," "New Workbook," and "This Workbook."
6. Type in a longer description for the macro in the "Description" box and then click "OK."
7. Walk through the steps you would like the macro to perform and then click "Stop Recording" when you are finished.
8. Right-click the object to assign the macro to it, and then click "Assign Macro," followed by clicking "OK."
9. Click the name of the macro found in the "Macro name" box.
Tags: then click, click Click, code group, Macro name, then click Click, within workbook
