Example 1: Daily Sales Total and Hourly Averageįor an example macro, you are going to run through a daily sales sheet, with the sales broken down by hourly totals. Click on your macro name and click Run to run your recorded actions. Clicking macros will bring up the saved macros in your workbook.
Once you record your actions, they are available on this same tab. The Personal Macro Workbook is in your user profile and lets you use your macros between your files. You can scope your macro to the Current Workbook, a New Workbook, or in your Personal Macro Workbook.
Click this, and a dialog pops up allowing you to name your macro and set a keyboard shortcut. You're looking for the third option in the Ribbon, Record Macro.
