*THANK* *YOU*, I was having a specific, maddening problem (maddening because I'm a total beginner at using macros) and your vid answered it clearly, quickly, without drama, cutesy music, requests to subscribe or other distractions. One the best tutorials I've found on YT, kudos.
Thank you this really cleared the confusion easily explained. By chance could you explain how to copy a Census record with the paste special some how you select “Text” so we can scroll though the sheet. It for some reason pastes transposed with mixed columns. I’ve asked many times from TH-camrs but no reply. This can be done in excel explained in Connie Knox’s Genealogy TV please help if you can
A macro is good for combinations you repeat frequently. If you create a leaderboard the same way and you do it over and over again, then it's a good candidate.
How can I turn off macro authorization in Google Sheets? When I copy the File that has macro the copied File has the macro but it asks for permission authorization again which is annoying to do it everytime. Is it possible to auto copy or turn it off as I make a copy of the File? Thanks!
Yes, you would have to write that in Apps Script. I don't think you can do that with any of the steps in this tutorial. Apps script is the underlying language in which the macro is recorded.
Hi.. can you tell me how to create a macro that selects a range of cells in a workbook and then goes to the file menu and gives a print command using google sheets?
I set a macro to "mark a payment amount Received" by placing an "r$" before the number. My problem is I may want run on a selection of cells or individually. For some reason, when i select multiple cells and run the macro, it only applies it to one cell. Can you help?
I'd have to see it. Another thing you could do is just have an extra column if and IF that looks to see if it's paid, and a CONATENTATE to join "r$" to the value of the cell.
Prolific Oaktree thanks for the response! I was half way able to fix it when I opened the script. Instead of “get cell” I changed it to “get active range”. Now my problem is it’s always replacing the existing number in the cell with that ever number I entered when I recorded the Marco. Do you know how to just place “r$” before “cell contents”
Google Apps Scripts are really for programmers who already know or are willing to learn an extremely verbose programming language - not for users who want to record simple or moderately complex keystroke sequences. As such it is misleading to claim that records macros. I almost did some very cool stuff until I discovered that success depended sensitively on conditions in the particular file in use. A waste of time.
@prolific oaktree I'm looking to create a worksheet that tallies daily, cumulative weekly and monthly stats on how we perform these activities we track daily. So when a person entered today's activities they would be captured. When they added tomorrow's and the next days.... activities you can see the daily number vs the cumulative number weekly, monthly, and year to date. It'd be great if there was column that stated daily goal so we could enter those numbered in front of each daily habit.
![[Full] 4 ต่อ 4 Celebrity EP.910 | 22 ก.ย. 67 | one31](http://i.ytimg.com/vi/4TR3MVpOiw8/mqdefault.jpg)
Something that I've avoided and been confused by since high school explained perfectly in 5 minutes. Cheers!
Glad it helped!
*THANK* *YOU*, I was having a specific, maddening problem (maddening because I'm a total beginner at using macros) and your vid answered it clearly, quickly, without drama, cutesy music, requests to subscribe or other distractions. One the best tutorials I've found on YT, kudos.
Great to hear!
Enjoyed your presentation style - quiet and simple, no stress, easy.
Glad you liked it!
The wildlife sounds in the background are great!
Thanks, I'm glad you liked it. My backyard sounds like that for about nine months every year. I never get tired of it.
@@ProlificOaktree must be nice. in what state?
@@mike20855 Pennsylvania
@@ProlificOaktree nice. I'm in MD. I'm in the burbs but want to move out to a SFH with some land. Would love to hear that while working from home
I work with Google Sheets a lot, but have never used Macros. This is so cool!
It's a brave new world.
Thank you!! This was such a great tutorial. I love your presentation style as well!
Omg! Easiest explanation eveeeeerrrr! Thank you for helping me understand Macros finally!
Thanks, good to have you around.
Very informative. This could help me a lot. Thank you very much.
Awesome! thanks so much for sharing this.
You're welcome!
Truly helpful, Thanks for the wonderful video.
Very well done. Thank you!
Cool, I'm glad you enjoyed it!
awesome video! Thank you!
Very helpful, thanks!!
Wow thanks so much!
Very clear and well done video. Thanks.
Hey, thanks! Glad you liked it.
tyvm for making these videos
Great video thanks!
for your teaching skills 🍷
Oh, well, thank you!
Thank you this really cleared the confusion easily explained. By chance could you explain how to copy a Census record with the paste special some how you select “Text” so we can scroll though the sheet. It for some reason pastes transposed with mixed columns. I’ve asked many times from TH-camrs but no reply. This can be done in excel explained in Connie Knox’s Genealogy TV please help if you can
Amazing. Thanks Adam.
Glad you liked it!
Thanks bud!
You're welcome!
How do I take individual personnel sales data (from individual pages) and create a leaderboard on a separate sheet? That's a macro function, correct?
A macro is good for combinations you repeat frequently. If you create a leaderboard the same way and you do it over and over again, then it's a good candidate.
can anyone explain me why i cant use google spreadsheet macro shortcut?
Could I use macro to select a certain position in a drop down list when I use the macro?
Thank a lot!
You're welcome!
Understood, thank you!
You're welcome!
How to bring values from one tab to another tab by running a macro
Thank you!!!
You're welcome!
How can I turn off macro authorization in Google Sheets? When I copy the File that has macro the copied File has the macro but it asks for permission authorization again which is annoying to do it everytime. Is it possible to auto copy or turn it off as I make a copy of the File? Thanks!
If your company is using spreadsheets for that, they should be using databases.
Also you can use other keys on your keyboard, or not use a shortcut.
So harsh!
It's Lit, Sir....
🔥
Thanks
No problem
This is so cool! Tym!
You're welcome!
What possible reason could you have to not let us save this video?
I don't control that.
Hey, is there a way to activate macro by changing a chosen cell. Lets say if cell a1="delete", makro is activated. Thanks for help
Yes, you would have to write that in Apps Script. I don't think you can do that with any of the steps in this tutorial. Apps script is the underlying language in which the macro is recorded.
Will this work on shared google sheets?
Yep!
can use macro to import data from google sheet to DHL post system (website)?
I doubt it.
Looks like G-sheets is just more powerful than Excel, just bot popular yet
Oh yeah.
Can i use a macro a different google sheet file? Or is the recorded macro only associated with the file it was created in? Thanks!!
Macros only work in the file in which they are recorded.
Hi.. can you tell me how to create a macro that selects a range of cells in a workbook and then goes to the file menu and gives a print command using google sheets?
I'm putting this question in the que to answer tomorrow during the live stream at 11 am. Hope to see you there. Look at my channel page for the link.
And during said livestream, I think the answer is that the printing abilities don't seem to be accessible to the macro.
How come I don't have a Tool menu ? Can't find macros !!!! Sams7ng Tablet S7
You need to do it through a browser, not a mobile app.
Is there Marco/VBA code for printing a column range?
Did you try to record yourself doing it for the macro?
Yes and it seems to not pickup the print step…
Therefore, was wording if a VBA code command
I don't know App Script very well, but I'm guessing you could do it. VBA is only in Excel.
How do we use macro buttons on smart phones?
I don't think you can.
How to enable a developer tab in in google sheet
Build a plug-in I guess!
I set a macro to "mark a payment amount Received" by placing an "r$" before the number. My problem is I may want run on a selection of cells or individually. For some reason, when i select multiple cells and run the macro, it only applies it to one cell. Can you help?
I'd have to see it. Another thing you could do is just have an extra column if and IF that looks to see if it's paid, and a CONATENTATE to join "r$" to the value of the cell.
Prolific Oaktree thanks for the response! I was half way able to fix it when I opened the script. Instead of “get cell” I changed it to “get active range”. Now my problem is it’s always replacing the existing number in the cell with that ever number I entered when I recorded the Marco. Do you know how to just place “r$” before “cell contents”
@@troybravenboer8133 I'm taggin' out on this one.
Prolific Oaktree thanks anyway.
Eyyy online class
Can u share this spreadsheet
Sure, I just added a link to the description.
How do you run a macro over and over and over? I don't want to click on it every time.
Make the macro contain the repetitions you need then run it once...or at least fewer times.
Can i do this on my tablet?
No, the option is not in the menus.
@@ProlificOaktree ok thanks, so it only works for PC right?
@@europebasedvlogs1251 PC, Linux, and Mac.
Is this work in android?
I don't think so.
Google Apps Scripts are really for programmers who already know or are willing to learn an extremely verbose programming language - not for users who want to record simple or moderately complex keystroke sequences. As such it is misleading to claim that records macros. I almost did some very cool stuff until I discovered that success depended sensitively on conditions in the particular file in use. A waste of time.
You don’t need Apps Script to record macros.
When it comes to Excel, MACRO is not what you describe in this video.
It's was a similar concept but with a different interface.
This is not the Kind of macros i was wanting to track.
It was more about how to do record them. The content of the macro will be personal to you.
@@ProlificOaktree I appreciate it lol I was trying to make a nutrition joke 😅
Oh. Accountants don’t understand jokes
🍕
@@ProlificOaktree you just earned yourself a new subscriber 😂😂
some steps are missing and its confusing
@prolific oaktree I'm looking to create a worksheet that tallies daily, cumulative weekly and monthly stats on how we perform these activities we track daily.
So when a person entered today's activities they would be captured. When they added tomorrow's and the next days.... activities you can see the daily number vs the cumulative number weekly, monthly, and year to date. It'd be great if there was column that stated daily goal so we could enter those numbered in front of each daily habit.
HOW CAN I GO ABOUT IT. Anyone?
Here's a video that has some aspects of what you are asking, it about summarizing quarterly though: th-cam.com/video/N6GdIzcx8sM/w-d-xo.html
Why can't I get a simple macro do work on my mobile phone. A macro that put up a text box saying Hi Robbie?
The phone app is super limited.