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 →
Copy sheet →
Instructions →
Macro recorder →
Absolute references →
Custom menu →
Google Apps Script →
Beginner tutorial for Google Apps Script→
VLOOKUP function in Sheets →
QUERY function in Sheets →
Sheets to Apps playlist →
Customizing G Suite playlist →
Subscribe to G Suite →
Product: G Suite development, Apps Script; fullname: AGV;
#SheetsToApps
#CustomizingGSuite
Credit: YouTube
