Once you have another sheet of data, go back to Developer and click Macros.

Macros really wouldnt work unless they were created exclusively for the Mac.

With Office 2016, Excel is using the same codebase on all platforms.

This change will make it easier for macros to work across platforms.

This setting is because macros can be a possible malware vector.

The easiest way to tell is to see if you have the Developer tab available on the Ribbon in Excel.

In the right-hand list, Developer should be at the bottom, click the checkbox.

Finally, click Save and you should see the Developer tab show up at the end of the Ribbon.

If you forget, Excel will remind you each time you try to save.

Youll also need to enable macros every time you open the file.

If youre not ready to start working with VBA, Excel lets you record the steps for your macro in an existing sheet.

Click this, and a dialog pops up allowing you to name your macro and set a keyboard shortcut.

You can scope your macro to the Current Workbook, a New Workbook, or in your Personal Macro Workbook.

The Personal Macro Workbook is in your user profile and lets you use your macros between your files.

Clicking macros will bring up the saved macros in your workbook.

Click on your macro name and click Run to run your recorded actions.

Your macro is going to add a daily sales total, and then add an average in the last column of each hourly period.

If you work in retail or other sales position, this is a helpful sheet to track revenue.

Using this first blank as a template to copy into a new tab each day could save you some time.

I used 24-hour time, but you can use AMPM notation if you prefer.

Then fill out your sales data for the day.

If you dont have data to populate this sheet, you can enter RandBetween(10,1000) in all the cells to create dummy data.) Next, click on Developer in the Ribbon.

In the dialog enter the name as AverageandSum and leave it stored in This Workbook.

You can enter a description if you need more details on what the macro does.

Your macro is now able to use on each new sheet you add to your workbook.

Enable Developer Mode In Excel For Mac