Hey there stranger!

Sign up to get access.

How to Record Macros

About this Tutorial

Record a macro, to Insert a column every day.

Featured Formulas

Video Transcript

 Hello, welcome to How to Record a Macro. This is gonna be super quick, so I'm gonna fill your head with like a ton of the reasons why we do this and why this is so awesome. In the past, um, when I was learning to do Google Scripts, uh, one of the things that was really, really hard was just. How to do basic functions.

Every single thing I needed to do at a row, at a column, insert this, split this, I had to Google every single one. But Google Sheets and Google has made it incredibly easy to figure this stuff out because you can record macros. Now. When I first started, this didn't exist. The learning curve was so steep, and now they flattened that learning.

and now you can learn so much really quickly by just knowing how to record macro. So one of the things that I do a lot in, in Google Sheets and we all do is like keep track of things maybe every month or every week, uh, or every day. And if, if you're tracking something every month, you have, you know, January, February, March.

and you have what you're tracking. Maybe it's follow account or it's sales or it's revenue. Um, and, and month to month, you're literally only working one time every month. So 12 times a year you're coming in here and, and doing this, but sometimes you're doing it 52 times a year, right? Every week or 250 times.

If you have to do five days a week, um, if you're doing, if you're.  adding like together revenue every day. Uh, you have to literally seven days a week, maybe some of those days you have to do three times, and then the other day you do once, you know, we end up going 25 more times into this document if we're doing this daily, uh, per year.

So here's something that happens is right, we go to the far left and we know every single Google shoot we ever start has 26 rows, right? It goes to.  and it has a thousand rows, right? But sometimes we don't need those thousand rows. We need like 200 columns. And so when you're adding a column, and this is what we're gonna do, we're gonna add columns today, and this is gonna show you how to record a macro.

Um, you c you go up here, you, you, uh, can delete columns, right? You can insert one to the right if you, uh, highlight every. What is that? Six columns you can insert six to the right. So what? What happens is like you're end up like, oh, I know I have to get a column for every day of the year. Oh, I go over here and like this takes a long time.

I have to like insert 22 and then I have to count, you know, time and time again. Here we can even see all, we can look at the column number, right? Sometimes we have to do the math, right? We have to be like, okay, az, how many, how many columns are in az? But actually, if you do column, this is like a super easy to way to count the columns.

Uh, you can tell, okay, this is column two. So if we know, oh, we have. Today, maybe today's data, and then we have column three, but we really want that to be one. Okay, so let's do minus two. So we now have one, and then we have 25 columns. Here we need 365. So how would we do that? Right? We would insert right, insert, right?

Oh my God, it's this taking forever. Here's how you record a macro. You go up to tools, macro. Record macro click. Now we're already recording the macro, so all I'm gonna do is go click. I'm gonna insert one to the left. That's just what we're doing right now, and that's it. Safe. Let's say insert row. Now we can even create a shortcut if we want to make that a keyboard shortcut.

Um, we can do that. Let's do that. Insert row to left. Save. So now all I'm gonna do is, hold on. I'm gonna do command option shift one, and now it's running. Oh, this is what you're gonna have to run into every single time you create a document with a script attached. You just have to get it to, for permission to run every each start at the beginning.

So you'll do that once, run into this, click that, and then yes, I want to allow.  and now sh command option shift one, and it's running the script. Then it'll say Finish script. Okay, let's do that again.

And every time we do that, we're adding a row. We know that because these column numbers are going up, right? What's really cool too,  is we can manage them. So in the next video I'm gonna show you how to edit this. Um, but I just wanted to get that really quick to you. You can even do one to the right. So you can go up to tools, macros, record, macro insert Right.

Save, insert column to right. Two, safe. Now we have a nifty little keyboard shortcut to the left. One to the left, and one to the right. One to the right. And see each one is adding. We can go here. Um, here's one thing. If you are using this macro to add like hundreds of columns, what I would suggest first.

And this is a pitfall you're gonna run to. Your sheet will slow down incredibly because it has a thousand rows. Many times when we're, we're taking, you know, daily data, we're not, we don't need a thousand rows, uh, a thousand rows. So what I would do is delete that, delete all those, and now we can add a bunch of rows.

And in the next video I'm gonna show you how to edit macros. Uh, and it's gonna be really, really cool cuz we're gonna be adding like,  not a thousand, but like 10 columns at a time or a hundred columns at a time. It's gonna make our job like so much faster, bite.

Courses

Sheet Stories / Video Notes + ADDED: Email Notifications

00:00:00

Fast FAQS

ChatGPT Clone in Google Sheets Part 2

Create an Internal Google Sheets Add-on

Why Different Cell References in AI Integration in Sheets?

Show Sheet Tabs Based on Edit

Add Title Case to Google Sheets

Getting Started Coding in Apps Script

How to Power Testimonials with Google Forms and Sheets

Seek Errors When Coding Apps Script

Think Like a Programmer: Develop The Mindset of an Apps Script Coder

ChatGPT Clone in Google Sheets Part 1

Embed a Number in a Website from a Google Sheet

Create Navigation Like A Book or Presentation

Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet

00:29:08

Hold a Giveaway Raffle in a Google Sheet

Capture Emails from Website Form to a Google Sheet (Without Zapier)

Embed a Headline in a Website from Google Sheets

Quickstart Tutorial OpenAI API in Google Sheets

Create a new Spreadsheet from just a Name in a Sheet.

00:05:21

Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?

00:05:43

Email Yourself a Cell from a Google Sheet, Every Day

OpenSea Data Inside Sheets

Create an Email Campaign Stats Calculator

00:35:13

Twitter App Clone in a Google Sheet

Dylan Asks: How to Automatically Delete Rows If Cell Contains Value

Highlight Row as You Move Your Cell Selection

Create a Timer with Apps Script

LinkTree in a Google Sheet

00:11:22

Password Protecting Data In a Google Sheet

Automatic Weekly Backup of Google Sheets

Create a CPM Custom Function (Create Better Calculators!)

Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script

00:12:29

What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users

Sync Two Tabs Without ImportRange()

Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.

00:00:00

Password Protecting Data In a Google Sheet Part 2 The Basics

Benoit Asks: How to Convert Case

00:07:35

Learn to Code in Google Sheets, For Programmers

Add a Checkbox to Turn on Dark Mode

00:05:10

Write Your First Script

00:08:31

Find Keywords in Any Column. Create quick search dropdown to find keywords

00:09:37

Basic CRM - Add a Powerful Script To Move Row Based on Status

How To Improve: 1,000 Business ideas: Business Idea Generator

00:11:20

Let's Make a Bookmarklet!

00:12:37

Troubleshooting Bitly in a Google Sheet Script

00:07:07

Unique Features - Design a Better Dashboard Part 2

00:04:13

How To Set Up Stripe Webhook to Google Sheets with Google Script

00:22:10

How to Edit a Macro

00:08:22

Sheet Stories / Video Notes + Clear 24 Hour Old Videos

00:35:10

Add A Timestamp to Task Lists (without Now Formula)

00:07:44

Make your Custom Functions Like Native Functions | Custom Function Autocomplete

00:17:58

Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop

00:23:26

New Syntax for WhatChanged Formula in Google Script

00:07:14

How to Record Macros

00:06:20

2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)

00:09:53

Deep Inside Dark Habits Google Script

00:18:54

How to Trigger Macros Daily

00:06:58

5 Ways to Create Coupon Codes | Create UUIDs

Create a Radio Button From Checkboxes Using Google Apps Script

00:15:01