Google Sheets - Macro Recorder Tutorial - How to Record an Apps Script
ฝัง
- เผยแพร่เมื่อ 16 มิ.ย. 2024
- Learn how to record a script in Google Sheets using macro recorder. This tutorial covers recording macros in absolute or relative mode, modifying macro script in Apps Script editor, tips & tricks during recording.
Damn, I need to watch this channel way more than I usually do.
Very helpful. Thank you for presenting the knowledge in such concise and clear format!
I speak spanish and your english and your explanations are so clear for me, thank you again, please keep doing this videos, I really want to learn to code in Google Sheets.
Just to thank you for your videos, I master so much things on Google sheets thanks to it. Very clear teaching tutorials
I just wanted to admire you! you are an amazing teacher and a genius. you have a very deep understanding and explain things very comprehensively. please keep making content for this channel. thank you
So helpful! Thank you very much for making this video
Great video. Thank you for making it
Excelente explanation!
Very good video. Thank you.
GREAT: Finally the time is come to get this simple and powerful functionalty ! But it is not (yet?) available in my version. i suppose that it will be released soon.
Great Work Bro
Very nice :)
Really nice video
thank you
Hi thanks for explaining, dose it work with android
awesome video! Thank you!
Is it possible to use the macro's on other sheets? So i don't have to record it again but it is standard available in my (new) sheets?
Hi thanks, how to browse a file via IMPORT under file to import the excel into the gsheet?
Good.
Hello! How can I record a macro, that changes that copies some text from the first sheet, and then pastes it to a second sheet, but also adds a row so everytime you add something in the first one it copies it to the other one with a button... I know how to do it on Excel, but not here!! HELP
Also, I want to thank you, you explain everything wonderfully!!
Thanks for this. I am using the "ctrl + shift + right and down" Then setting a named range. If I play the macro back it always sets the named range to the absolute ref from before. How do you get the macro to set the active ranges to the named range?
It will only work for simple formatting and stuff like that, at least for now.
You will need to write your own script for this. Something like this should work
function namedrange() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
spreadsheet.setNamedRange('abcdef', sheet.getRange(1,1, sheet.getLastRow(), sheet.getLastColumn()));
}
How to get macro recorder option in tools manu
Into my spreadsheet I am not get this option what should I do
still not there?
Hi, how to use macro function on android?
🙏🏻
This video is very helpful. I want to collect students fee in google sheet. I need a macro to fetch basic information into sheet2 from students data sheet1. I'll add payment detail and when I press submit data will store into sheet3 and sheet2 data will be erased. would you please help me doing this?
Thank you this going to save a lot of time of doing my reports hahah but i have a concern does applying macro and edit script will make our data publicly viewed by others?
No, i don't see why it would make it publicly available.
@@ExcelGoogleSheets okey, thank you I will do practice it today and apply it to my report
Can i implement them in Google sheet ? Can you pls tell how to create Login id Password form , using Google sheet which i can use google sheet
Hello, I just wonder if you could help me,, I just want to record very simple macro on spreadsheet,
Select A1, copy (CTRL+C)
Select A2, copy (CTRL+C)
Select A3, copy (CTRL+C)
Only this 6 actions. This is [Copy append].
I want to paste these data to some other application, like email.
Is it possible to record macro to complete this simple task on the spreadsheet?
I am really in trouble figuring out..
I dont have a macro section in my tools. Do you need to install it somehow?
They moved it under Extensions now
macro recording option was not available previously ?
Fahad Bari
How to get macro recorder option
Yes. Its a new feature that was added
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?
You can't click on print with a macro.
The MACROS option is NOT under tools anymore, its under "EXTENSION" toolbar, same goes with APPSCRIPT that's now under "EXTENSION" toolbar
nice
At 18:40, why not follow your own advice? That is, instead of manually highlighting the R1 entries, click A1 and use CTRL-SHIFT-Right to select the 1st through nth headers (so that the macro adjusts to future templates with a different number of columns)?
CTRL-SHIFT-ARROWS stops at blanks. They are OK if you don't have any blanks in your data.
Hi how to record a published sheet addon in G-sheet macros
You can't.
HOW do you get Macro on Sheets? I don't have the option. Do I have to install something first?
Under Executions menu now.
How to get macro recorder in google sheet
They are rolling out the updates. If ti's not available now it will probably show up within a week or two.
Is it html or java?
JavaScript.
Learn Google Spreadsheets
What is your spreadsheet version
Because I am not getting option of macro recorder please help
Why doesn't it record printing steps?
Printing is something that is being executed on your computer. I doubt Google Sheets macros will ever do that since Apps Script code runs on Google's servers.
anyone wants to help me with a macro? i have no idea what im doing
I appreciate your doing these videos; you helped me. But man, it would sure help if you had planned the content ahead of time, so we didn't have to wait while you figure out in real time how to show something. That gets painful. Maybe you could do a little editing afterward to speed it up a little?