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.
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!