If you’re regularly working with data, but lack the interest, financial means, or need for a flowery data management platform, there’s no got to panic. As we’ve shown throughout this series of articles, good old Google Sheets is capable of tons quite you would possibly realize.
However, knowing all of Google Sheets’ neat formulas is one thing. Using it on scale is another. That’s where macros are available.
A macro may be a sequence of instructions which will be repeated all directly. Macros also exist in Google Sheets, allowing you to record yourself performing a series of tasks.
Macros use case
Let’s say you’ve got a sheet containing an imported data table, and you now want to import an equivalent table but with updated figures. The first table may need two columns: A and B. you would possibly want to feature these figures together, creating a column C. Then you opt to feature filters to the headers, and type the sheet by the combined figure in column C.
The problem is, as you’re importing the new table of knowledge , you’re overwriting the sheet’s previous data, including the manually added column C. to stop that from happening, or a minimum of to prevent you having to manually add that column again and type the table by it, we will use a macro.
Using macros in Google Sheets
When you’re done, click Save and provides your macro a reputation. Next time, rather than performing the sequence of tasks by hand, simply select the macro from the menu.
You can create multiple macros within the same Google Sheets document to automate boring, repetitive tasks. So, what are you waiting for? Back to figure, you productivity wizard!