About 1,089,875 results (3,970 milliseconds)
Google sheet macro - complete status moves row to another tab and ...
https://support.google.com/docs/thread/28381517/google-sheet-macro-complete-status-moves-row-to-another-tab-and-clears-certain-cells-in-current?hl=en Feb 11, 2020 ... In excel for example, you would set the found row of 'i', then put "B" & i which would say column B row whatever found row is, and so on. Once ...
script editor does not show in google sheets/tools - Google Docs ...
https://support.google.com/docs/thread/93524392/script-editor-does-not-show-in-google-sheets-tools?hl=en Jan 14, 2021 ... Is the file you are opening a Google Sheet or a MS Excel file? I ... Yes the spreadsheet now shows red cells but I didn't run the macro.
Google Sheets Macros | Apps Script | Google for Developers
https://developers.google.com/apps-script/guides/sheets/macros Importing functions as macros · In the Google Sheets UI, select Extensions > Macros > Import. · Select a function from the list presented and then click Add ...
Button with Macro to download sheet as .csv file - Google Docs ...
https://support.google.com/docs/thread/188230855/button-with-macro-to-download-sheet-as-csv-file?hl=en Nov 12, 2022 ... If you want to have the file placed in a folder that is dedicated to these files, we will need to add the ID of the folder into the code. If you ...
I want to create a macro to apply a filter (created in Data tab) then ...
https://support.google.com/docs/thread/42520476/i-want-to-create-a-macro-to-apply-a-filter-created-in-data-tab-then-copy-and-paste-into-another?hl=en Apr 25, 2020 ... The rest of my macro works to clear the destination sheet and paste the data and turn off the filter. Just the data to paste is incorrect ...
Positioned in a particular tab when open a google sheet - Google ...
https://support.google.com/docs/thread/33145022/positioned-in-a-particular-tab-when-open-a-google-sheet?hl=en Mar 12, 2020 ... The Java script is completely new to me. I thought you could do this without going through macros? It is possible in EXCEL. Here is the macro ...
Use macros and add-ons - Google Docs Editors Help
https://support.google.com/docs/answer/9331168?hl=en ... macros in Sheets, just like Microsoft Visual Basic for Applications does for Excel. ... Click Save macro and close the tab to return to your spreadsheet. Repeat ...
I need a script to clear certain cells in sheets when a button is ...
https://support.google.com/docs/thread/5809954/i-need-a-script-to-clear-certain-cells-in-sheets-when-a-button-is-pressed?hl=en May 9, 2019 ... ... sheet I was working on so I fiddled around with the record macro. I simply clicked record macro and then manually cleared out the cells I ...
Looking for a script to create new tabs based on cell values, then ...
https://support.google.com/docs/thread/102763612/looking-for-a-script-to-create-new-tabs-based-on-cell-values-then-query-formula-in-the-new-tabs?hl=en Mar 18, 2021 ... ... sheet with the value. // this is the addition to add the formula to the new tab. ss.getSheetByName(tabName).getRange("A1").setFormula('QUERY ...
Is it possible to set the "Tab Index" of specific cells in Google Sheets ...
https://support.google.com/docs/thread/10619354/is-it-possible-to-set-the-tab-index-of-specific-cells-in-google-sheets?hl=en Jul 25, 2019 ... offset(0, 0)...will jump one cell below but then jumps back to original cell like Excel's "Ctrl+Enter". ... macro functions and many ...
In google sheets can I set it so that all cells word wrap and align at ...
https://support.google.com/docs/thread/4372413/in-google-sheets-can-i-set-it-so-that-all-cells-word-wrap-and-align-at-top-by-default?hl=en Apr 17, 2019 ... var sheet = spreadsheet.getActiveSheet();. sheet.getRange(1, 1, sheet.getMaxRows(), sheet.getMaxColumns()).activate(); ... macro to a button ...
In google sheet, how to clear all filters rules in 1 click without ...
https://support.google.com/docs/thread/19196689/in-google-sheet-how-to-clear-all-filters-rules-in-1-click-without-deleting-the-filters?hl=en Nov 10, 2019 ... I am very interseted in learning the step by step procedure for setting up such macro and script. ... I migrated quite a complex Excel worksheet ...
OPEN A HIDDEN TAB WHEN CLICK A CELL OR LINK IN A CELL ...
https://support.google.com/docs/thread/88037314/open-a-hidden-tab-when-click-a-cell-or-link-in-a-cell?hl=en Dec 10, 2020 ... This question is locked and replying has been disabled. I have the same question (3).
How To Resize Columns Across Different Sheets; Google Sheets ...
https://support.google.com/docs/thread/136885169/how-to-resize-columns-across-different-sheets-google-sheets?hl=en Nov 23, 2021 ... Open the first Sheet then click Extensions to the left of the Help button in your top menu. 2. Then click Macros > Record macro. 3. A pop-up ...
How to link one spreadsheet tab to a cell in a different spreadsheet ...
https://support.google.com/docs/thread/13305507/how-to-link-one-spreadsheet-tab-to-a-cell-in-a-different-spreadsheet?hl=en Aug 31, 2019 ... I have tried inserting the link for each tab but it still opens the entire workbook of templates. Would a macro work for this situation? I have ...
How do I make the "add-on" tab in the toolbar of Google Sheets ...
https://support.google.com/docs/thread/159257440/how-do-i-make-the-add-on-tab-in-the-toolbar-of-google-sheets-appear?hl=en Apr 9, 2022 ... I have googled to find out how to go about doing this. One advice given was to convert Excel spreadsheet to Google Sheets. But, my original file ...
Script for creating new tabs that are automatically named and ...
https://support.google.com/docs/thread/242084005/script-for-creating-new-tabs-that-are-automatically-named-and-populated-from-a-roster-and-master-tab?hl=en Nov 2, 2023 ... I'll make do for now with no scripting. lol... i was trying to save myself work, not add more by learning Javascript from the ground up. Thanks ...
My Apps Script doesn't seem to run for other people - Google Docs ...
https://support.google.com/docs/thread/41307278/my-apps-script-doesn-t-seem-to-run-for-other-people?hl=en Apr 20, 2020 ... Do I need to share the Project separately from sharing the Sheet? Is there some permissions setting under their account that they have to enable ...
Help needed: how can a run a macro assigned to a button in a ...
https://support.google.com/docs/thread/123291437/help-needed-how-can-a-run-a-macro-assigned-to-a-button-in-a-specific-cell-in-a-specific-sheet?hl=en Aug 28, 2021 ... You will then be able to run the macro from another sheet, and it ... spreadsheet.getRange('A1').activate();. and just above that line ...
Use filter function to adjust existing formulas. - Google Docs Editors ...
https://support.google.com/docs/thread/2049413/use-filter-function-to-adjust-existing-formulas?hl=en Mar 4, 2019 ... My thought is that this is similar to recording a macro in excel and attaching that macro to a button. ... add an f to the location tab references ...