Coding Google

Skip the Mundane with Macros

In my company, we use a Macros on one of our spreadsheets. This Excel spreadsheet is before my time, and honestly its a little complex. So I have always deterred people from using Google Sheets as a way to run this Sheet.

This week, Google released an update to Google Sheets. You can now record macros in the cloud to automate repetitive tasks. Check it out:

Now this is pretty cool because its writing code…without writing code. Much like recording an action in Adobe Photoshop.

Google Sheets sees that you are recording this macro. As you record it, the actions get automatically put into an Apps Script. You can save it, name it, and even edit it once you are completed with it.

Google even allows you to write your own Apps Script and import them as new macros.

Since these new Sheets macros are designed to be in the cloud, you can run them at the same time that others are working in the sheet without interrupting them!

This is a big deal and a huge step forward for Sheets to eventually overtake Excel in my mind. It still has some time, but it can be done!

Google On!

"Have you ever tried to count Hyperactive Children, while someone yells random numbers in your ear? Well that is what it is like in my head all day!" Trevor is apart of the robot revolution to slowly take over the human occupants of this Earth. By day Trevor is your above average Tech worker, tending his servers (Anton, Deckard, Anakin, Dimitri,and Scotty), and herding his 450+ employees. Yet at night...he sleeps, or as much sleep as he can get. Ideas always forming in his head with each new marvel and innovation to arrive. Each thing helping him to decide to help his robot overlords more and more. Trevor holds a few different designations: -Google Certified Administrator -Microsoft Technology Associate -Microsoft Specialist: Configuring Windows Devices -Microsoft Certified Professional -Microsoft Office Specialist He loves reading, working on SMART homes, and writing about his passion for Google products and innovations. He and his wife live with their 2 dogs and 3 cats in their quiet little beach town. Feel free to reach out to him!