How macros can be used to build Apps Scripts for cleaning data

Опубликовано 2 июля 2020, 16:00

Cleaning up data from downloaded accounting reports or from other systems can take up valuable time and resources. In this episode of Sheets to Apps, we’ll walk you through adding automation to your monthly Excel accounting data that records your steps into a script that you can run repeatedly with Google Sheets macro recorder.

Previous Episode → goo.gle/2NDUbYl

Copy sheet → goo.gle/2CS8ruu
Instructions → goo.gle/2YLm1Zb
Macro recorder → goo.gle/31vhpYK
Absolute references → goo.gle/3idAgxv
Custom menu →goo.gle/2UaZItR
Google Apps Script → goo.gle/3cMWwLz
Beginner tutorial for Google Apps Script→ goo.gle/2zOtDA6
VLOOKUP function in Sheets → goo.gle/3dFBw9f
QUERY function in Sheets → goo.gle/3eVlcCo

Sheets to Apps playlist → goo.gle/SheetstoApps
Customizing G Suite playlist → goo.gle/2Rp30br

Subscribe to G Suite → goo.gle/GSuite


Product: G Suite development, Apps Script; fullname: AGV;

#SheetsToApps
#CustomizingGoogleWorkspace