Click here to visit Original posting
Google has rolled out updates to Sheets, including the ability to record macros - part of the company’s plan to appeal to more business users with it G Suite cloud product portfolio.
Macro recording provides a way to automate repetitive tasks within the G Suite spreadsheet tool, potentially saving users hours of duplicated effort.
The macro recorder lets users record actions within Sheets and then play them back without writing code. Once recorded, a macro is automatically converted into an Apps Script – a Google scripting language derived from JavaScript. This can be later edited to update the macro, rather than forcing users to re-record it completely.