Questions tagged [google-sheets-macro]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
18 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
vote
0answers
27 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
22 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
301 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
61 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
265 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
91 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
439 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
1answer
413 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
413 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
661 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
87 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
975 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
680 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
739 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 ...