Questions tagged [google-sheets-macro]
The google-sheets-macro tag has no usage guidance.
16
questions
0
votes
1answer
17 views
Macro to move down and separate data
I wish to use a macro in Google Sheets to
find the number 1 in column A
then move that corresponding row and all following rows down to start at A9 row
then find the number 2 in column A
then move ...
0
votes
0answers
15 views
With Google App Script activate a cell so it is ready for user to edit
I have a Google macro in which I do a few things, then want to end the script in an activated cell so the user can immediately begin typing in the activated cell (without clicking it).
I do some ...
0
votes
1answer
7 views
Macro to copy and paste values from multiple cells as text into a Note
I'm new here and struggling a bit with the javascript in macros. I just need a steer as to how to get a macro to copy from a range relative to an active cell.
I'm a showcaller, that is, during live ...
0
votes
0answers
17 views
Is it possible to create a keyboard shortcut for changing the color of a cell in Google Sheets? [duplicate]
I often find myself manually changing cells in a Google sheet to be a particular color. Is it possible to create a keyboard shortcut for changing the color of a cell?
0
votes
0answers
91 views
Script trigger to Google Sheet that will work in Android mobile app
Would someone please help me script a trigger to start a macro in Google Sheets running on android 7.0.
As Probaton asked in 2015 I have a similar problem. My macro works great in Google sheets on my ...
0
votes
0answers
15 views
Use something other than ctrl+alt+shift+number for macro shortcuts in google sheets
I can't use any shortcut that includes both alt and shift keys since in my keyboard alt+shift changes the keyboard language. Is there any way to use some other combination? I tried to edit the ...
0
votes
0answers
11 views
Finding a cell value based on row and column
I have a little problem that might not be solved just with formulas. And I am not so advanced in JavaScript yet.
I have a list of products, our salesmen, customers and time when and how much the are ...
0
votes
1answer
62 views
Variables in Google getRange
I have a simple need to copy a range (E4:G4) and paste it X rows below, determined by the value of a cell, C2. I think I may be misunderstanding the offset function since when I run the routine, I get ...
0
votes
2answers
160 views
Simple Google Sheet Macro. Save it, Run it, Fail it… Range Not Found
Not sure what's going on here. I want to copy the data from one tabbed "sheet" within my Google Sheet to another.
I set up Record macro. Navigate to data sheet tab. Copy all (via click in top ...
1
vote
1answer
165 views
Writing a macro to create a new tab and name that tab based on a cell value in Google Sheets
I would like to have a Macro that generates a new tab and names that tab based on a cell value.
There is a tab called 'Dashboard'! on which the user enters information in assigned cells. Afterwards, ...
-1
votes
1answer
30 views
How can I make an attendance table that automatically deletes obsolete day and creates a new?
I need a Button that deletes the entry of the first column(A:A) and creates a new one(H:H) and the Date at cell H2 to automatically set to the next Thursday or Sunday.
Currently, I just recorded a ...
-1
votes
1answer
32 views
Automatically name current version when Google Sheets is opened
I'd like to automatically maintain the original version of a Google Sheets file whenever the file is opened. Manually, this would involve simply opening the file and selecting File/Version History/...
0
votes
1answer
477 views
How can I disable the authorization needed to open Google Sheets Macros?
Whenever I try to open any macro enabled sheets it requires authorization, even though it's a first party application. Is there any way to stop Sheets from asking it or give permissions to everyone I ...
0
votes
0answers
14 views
Add one column after E column in all sheets [duplicate]
any ideas how can I add a Column after a determinate column in all sheets in one time?
1
vote
1answer
476 views
Is it safe to use macros I created in Google's web apps?
I recorded a macro in Google Sheets, which can be done by going to Tools > Macros. However, when I try to run it, I am asked for permission to for it to be run.
I get the following messages:
...
0
votes
1answer
629 views
Macro in Google sheets put data in empty cell every month
My question
pick up date and write in the following empty line?
I want to copy a data from a fixed cell to a database and that it always comes under the last line.
For example, Data from cell A1 from ...
