How to Trigger Macros Daily

<div> All right. Right now we're gonna be doing one of the most time saving things ever. We are going to add a column and then copy and paste today's data along with today's date into the next column. This is really cool. Right now we have today's date, literally saying today's date Here, we have columns that have numbers here, and we have our numbers, and we wanna say, Hey, this follower account, or this sales, or this revenue came on this day. Okay, so how do we do that? First, we're gonna use a function today. This is gray function that literally changes every single day.

It tells you the date. Pretty simple, right? What We're going to record a macro and then run it every. Actually, what we're gonna do is we're gonna record a macro , we're gonna edit it, and then we're gonna run it every day. So we're gonna right click insert, right? This is what we're gonna do. We're gonna insert that. We're gonna take this column, 'em, copy paste values . We're gonna format this to a date and. That's our what? That's what we're gonna do. Okay, so how do we do that? You already know where to record a macro.

So let's record a macro for tools. Record macro recording a new macro . Click here, you're gonna right click. Insert one to the right, go back. We're gonna copy click paste. Values only. Click in the C1 format number eight. Cool. That's it. Save. We're gonna do save daily data. Now we could do a shortcut here, but we don't want a shortcut. We want the computer to run it every single day. Okay. First we're gonna edit the. So there's a couple things we have to do to it in order to let it run every day. So here's our macro. What that exactly as we recorded.

I haven't changed anything yet. What I'm gonna do is I'm gonna delete this activate cuz we don't need it to activate. It's gonna run without us. We want it to run on set sheet by Nope. GI sheet by. And we are going to use daily. We don't need this activate active sheet cuz there is no active sheet . It's daily. I'm gonna do command S and look, we have, let's go over what this is. It's getting the range B. It's saying insert a column, it says offset it, then copy two. It's copy. And then it's pasting the values over here. Okay.

We can also get rid of this activate, and that should go to c1, which is now the new column, and set that number format . Okay, so let's see if it doesn't. Let's go to tools. We always wanna check our macros. We'll run the macro . It's running the. Okay, so one of the problems that I just realized is that you actually do have to include the activate if you are not on it, or it will go to a relative wherever your cursor is. So leave those activates in there and now we can be anywhere.

Let's do, let's delete these to see if it works, so we can be on summary, let's run that. Macro and it's running the macro . Cool. So now we want this to happen every day, right? Whoever puts in these numbers might not remember to add this row, add this column and copy paste this, right? So how do we do it every single day? This is gets, it's gonna get a little complic. Okay, so if you are in here and you wanna run a macro , you're like, Hey, this macro that I've been using every day, I would rather it just happen without me.

You're gonna go to script editor . You could probably have to dismiss this message. It's just a message telling you that they're updating. We have a macro . We know our macro is saved daily data , so you're gonna go to edit current projects triggers. We're creating a trigger here, and so here we have a list of all the triggers. Right now we have zero triggers, so let's add one. Let's move my face over here. I'm gonna add a trigger and it's gonna choose a function . We, if you have more than one function , it's gonna be listed here. You can save daily data.

You don't have to change this. There's nothing. Change it to you do wanna change the select event source from spreadsheet to driven and instead of every hour, you wanna do it every day. You could do it every hour. That's. 24 times 365 select the time of day. Maybe just midnight to 1:00 AM is fine. If it fails, you're gonna be notified every day. You should say that you should get this because it'll give you an email to really helpful email. I've been notified sometimes when it used to have, there used to be a limit to. The sheet size.

So if it, it couldn't add a column, it would notify me. Or there was a weird thing where you needed essentially a blank. It's it finds the last non blak. I had a script where it found the last non blank row, and then added a row after that. But if there was no blank rows, it would. And so I didn't realize this, somebody had filled in that last final row, not adding the blank row. And so it, it pinged me and said, Hey, failed. It was very helpful. So let's save it. So now we have here owned by me head save time base, save daily desk.

So you saw that information before and it's gonna run every day. And now you have a sugar that runs every. That's it. Bye.</div>