How much time do you spend always doing the same operations on Google Sheets? What if I told you that you can create functions that do the job automatically for you, without coding at all? Of course it is possible!
You can do this with Macros. These are custom features that you can create within Google Sheets to automate some repetitive tasks that you would otherwise have to do manually.
The nice thing about macros is that you can create them without writing a single line of code!
You only need to carry out the steps once and you can apply them with one click as many times as you want!
And for the more geeks who want to get closer to the world of Quick Simplified Programming there is a nice surprise: for each macro you create a function is automatically generated in Google Apps Script where the steps performed are transformed into JavaScript code!
In fact, you can make changes to the code or take a cue to create other more complex custom functions. For example, you just need 2 more lines of code to generate a PDF file and one more line to send everything by email to the desired recipient :)
[IL LIBRO - ENG] Aim high with… Google Apps Script: https://www.amazon.it/Punta-alto-Goog...
Google Apps Script Tutorial in Italian: https://www.appsscript.it/
#SimplifiedQuickProgramming #GoogleAppsScript #Macro #JavaScript