Macros in Google Sheets

A major sticking point with moving from Excel to Google Sheets was the lack of ability to use macros. A macro will let you automate calculations and other aspects in sheets. For instance, if you regularly tally up marks, allocate a grade and then draw a graph or chart of the results for your class, then you can create a macro to do this for you. Google Sheets now have the capacity to write and run your own macros. This will improve your efficiency and save you time.

Google Sheets now have the capacity to write and run your own macros Click To Tweet

It is simple to build your first macro and save it in a Google Sheet. The great thing about macros in Google Sheets is that they are accessible whenever you use the sheet as they are cloud-based. They are written using Google Apps Script, but you don’t need to understand how to program using this code because you can record a macro within a Google Sheet. Unfortunately, you are unable to import macros from Excel at this stage as they use VBA as the code to make them run.

To build your first macro, follow these easy steps:

1. Create, or open an existing Google Sheet that has some data in it. For example, you may have a mark book with some marks in it.

2. Decide on what action you want to carry out, in the example here I want to convert the raw mark to a percentage.

3. Click on the Tools tab.

4. Click on Record macro

The macro window will now open and indicate that you are now recording a macro.

Complete the calculations and formatting that you want to have in the sheet.

5. When finished, click on save and name the macro.

Running the macro is just as easy:

1. Click on Tools
2. Choose macro
3. Click on the macro you have just written.

From here, you can also edit the macro by editing the underlying Google Apps Script:
1. Click on Manage macros.

2. Click on the three dots.

The apps script looks like this and you can edit it directly.

This macro will stay with this sheet. If you wish to use it in another sheet, you can download the script and then install it in another sheet.

Macros make your spreadsheet life more efficient and are now included in Google Sheets. Watch this video to see how easy it is to create a macro in a Google Sheet Click To Tweet

Macros make your spreadsheet life more efficient and are now included in Google Sheets. Watch this video to see how easy it is to create a macro in a Google Sheet.


Ways to Use Google Slides in the Classroom- Part Three

Google Slides is one of the most versatile apps in the G Suite suitcase and can be used very effectively to provide more student agency within your classroom. The ability to link within slide decks or out to other files can add another level of functionality for both the teacher and the student. This is part three of a three part series.

VIEW POST
Letter merge email

How to mail merge letters in Google Docs

In a recent post, we shared the top five add-ons you can use to perform a mail merge in Google Drive. In this post, we’ll show you how to use one of those tools, autoCrat, to perform a mail merge in Google Docs that creates and emails personalised letters. This same technique can also be used to personalise any other type of document that is based in Google Docs.

VIEW POST

Top tips for working from home by a remote working team

  With Google Drawings a lot of people don’t realise that it actually sits inside Google Docs. Inside Google Docs you actually have the Google Drawings tool. Under insert you’ve got Drawings and now there are two places that you can get a Drawing from. The ‘New’ is going to

VIEW POST

Here’s What
Our Clients Say

PR Industrya

Client

In 2018, Using Technology Better designed and delivered a two phase post-migration training program for this New Zealand based graphic design firm. The initial goal of the training program was to reduce frustration with G Suite, with the long term aim of facilitating a change in culture and collaboration that can lead to transformative practices