Questions tagged [google-sheets-macro]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
21 views

Add one Column to Another, Then Delete the Column

This is a messy function but it works. I want to input values into column D, use the macro, have it add D values to C Values across from one another, then Delete all D values. I could write out C3:...
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
35 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
459 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
79 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
1answer
108 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
469 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
497 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
456 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
773 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
105 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
1k 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
718 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
765 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 ...