Hello Jordan, talking about attendance I'm trying to link a google form OnFormSubmit and OnEdit to update an attendance table. Due to social distancing rules many gyms would need to keep track on who enters for 14 days; I have a few ideas, but even with the help of your videos I'm not really able to do that. May you give me some tips? Thanks
Jordan, first off Thank You for this video! I know it has been awhile since you posted this, but I am trying to figure out how to copy a range of cells (C2:AU25 to be exact) from one sheet to a different one when there is a change on the source sheet. If you are able to give an example of this or are willing to connect I would gladly share my workbook with you to see what I am trying to accomplish. Thanks again, I really appreciate your videos!
Thank for the video. I'm having trouble trying to figure out how to run the same script on all pages. My code whatever I put does not save onto another page
Hello, I need your help! I want my Google Excel sheet every 2 minutes to execute a macro that I made. How can I do it, what would the code be? I am new at this.
Hi Jordan Thanks for the video. Can you please help me with script for executing a trigger at sharp 9:01 pm on daily basis. Currently I am performing task manually by setting triggers. Appreciate your reply at earliest.
You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these raws for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.
Hello Jordan, talking about attendance I'm trying to link a google form OnFormSubmit and OnEdit to update an attendance table. Due to social distancing rules many gyms would need to keep track on who enters for 14 days; I have a few ideas, but even with the help of your videos I'm not really able to do that. May you give me some tips? Thanks
Jordan, first off Thank You for this video! I know it has been awhile since you posted this, but I am trying to figure out how to copy a range of cells (C2:AU25 to be exact) from one sheet to a different one when there is a change on the source sheet. If you are able to give an example of this or are willing to connect I would gladly share my workbook with you to see what I am trying to accomplish. Thanks again, I really appreciate your videos!
@Jordan Rhea what if i want to change a value of a cell if condition is true else it will retain it original value?
Thank for the video. I'm having trouble trying to figure out how to run the same script on all pages. My code whatever I put does not save onto another page
Hello, I need your help! I want my Google Excel sheet every 2 minutes to execute a macro that I made. How can I do it, what would the code be? I am new at this.
you can use triggers, correct me if I'm wrong.
Hi Jordan
Thanks for the video. Can you please help me with script for executing a trigger at sharp 9:01 pm on daily basis. Currently I am performing task manually by setting triggers. Appreciate your reply at earliest.
You are always making amazing videos ✌️👌😁. But, I am currently struggling with Google sheet online in which I am trying to create a protection in the enter sheet only those cells and columns that has a specific word, so in a nutshell, I want to make automatic protection based on conditional. For instance, I have a data entry in which the team leaders fill it and I have a column to approve them, if I said yes then automatically lock these raws for them, and if it was no then leave it as it is. Thanks in advance. I have searched a lot but didn't find anything like this.
thank you..