Questions tagged [google-sheets-macro]
The google-sheets-macro tag has no usage guidance.
19
questions
0
votes
0answers
10 views
Can I create a Google Sheet macro to take the content from one cell and make it the hyperlink for another cell?
I do a report every month that has a column of Page titles and the next column is the URL. My boss wants the page titles to have the hyperlink applied to them so we can remove the hyperlink column. I'...
-1
votes
0answers
6 views
How to loop through individual sheets [closed]
We are trying to display our sheets on a television in our shop. Each workbook contains separate sheets for each machine. We want the display to automatically rotate through the sheets every 15-20 ...
1
vote
0answers
20 views
How to Use Google Sheets' Macro to Copy Data from Volatile (randbetween) Cell
What I would like to be able to do is execute a macro that copies the data from a cell with a randbetween formula, and pastes that data (copy/paste values only) into another cell. When I attempt this ...
0
votes
1answer
16 views
Google Sheets: Supplement cells automatically
My goal is a function/macro/script that automatically inserts a text in every selected cell by a key combination (or similar). The inserted text needs to stand at the beginning as seen in the example ...
0
votes
1answer
144 views
How to select and remove drawing object in macro
I have a Google Sheet template with a button that triggers a macro to make a new copy of itself that can than be edited (code below). I'd like the macro to remove the button on its copy, as there's no ...
0
votes
1answer
36 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
116 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
37 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
18 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
346 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
41 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
1answer
277 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
356 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
478 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
31 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
65 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
808 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 ...
1
vote
1answer
614 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
696 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 ...
