2022 Developer Survey is open! Take survey.

Questions tagged [google-sheets-macro]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
35 views

Move row to very bottom of sheet (Google Sheets Apps Script)

I have a google sheet with a specific number of rows, and I want to use a script/macro to move a certain row to the very bottom. const DESTINATION_INDEX = 4; function myFunction() { const ss = ...
user avatar
  • 253
0 votes
0 answers
14 views

Help with automated pivot table coding based on cell inputs

I am trying to code a macro to automate the creation of a pivot table based on input values from cells with drop down menus. What would be the best way to go about coding the variable inputs for the &...
user avatar
  • 1
0 votes
1 answer
18 views

Possible to make a Google sheet macro available to all sheets I access?

I have created a very basic google sheet macro that reformats columns by automatically adjusting their widths, and then widening the column(s) by a certain amount, to avoid crowding columns next to ...
user avatar
0 votes
0 answers
42 views

Run a set of assumptions through a formula

I hope you can help! I am trying to forecast revenue for a business, and determining the revenue per client is quite complicated, and there are many factors at play. The simplest way I found to do it ...
user avatar
0 votes
1 answer
54 views

Script for macro button to transpose and paste data from selected row to selected cells

I need to come up with the script for an import button on my google spreadsheet, but I'm a little out of my depth. I have one Spreadsheet with two Sheets: Purchase Order template (Sheet2 = 発注書) ...
user avatar
0 votes
1 answer
15 views

Filter columns with a dropdown

I need your help with a somewhat dynamic drop down filter. I have a drop down list in cell B6 that states categories that appear in column "E". Below the drop down list I have a table with 5 ...
user avatar
  • 1
0 votes
1 answer
29 views

How to emulate behavior or cmd + down arrow in Google Sheets Macros?

If there is a column of 10 full cells in a row, and you go to the top of the column and hit command + down arrow, it activates the lowest non-empty cell. I tried to record a macro while using cmd + ...
user avatar
0 votes
1 answer
44 views

Solver in Google Sheets Macros

Is it possible to automate Solver in a macro in Google Sheets? By that I mean setting and changing the Solver parameters within a macro. I am able to do this in Excel but I can't find a way in Google ...
user avatar
  • 3
0 votes
1 answer
28 views

How to enable macros

Looking for some insight. In Google Sheets I added a series of buttons linked to macros. Works just fine for me and another user. Other users are telling me that they click the button and nothing ...
user avatar
0 votes
1 answer
115 views

Google sheets macro to run on worksheet change

I have a simple macro in Google Sheets that I can run from Tools > Macros > MacroName. I have it set up with a trigger to run when the spreadsheet is first opened. (All the macro does is go to ...
user avatar
  • 149
0 votes
2 answers
24 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:...
user avatar
1 vote
0 answers
73 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 ...
user avatar
0 votes
1 answer
27 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 ...
user avatar
  • 1
1 vote
1 answer
1k 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 ...
user avatar
  • 11
0 votes
1 answer
123 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 ...
user avatar
0 votes
1 answer
145 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 ...
user avatar
0 votes
0 answers
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?
user avatar
  • 145
0 votes
1 answer
695 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 ...
user avatar
  • 3
0 votes
2 answers
656 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 ...
user avatar
  • 101
1 vote
1 answer
1k 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, ...
user avatar
  • 11
-1 votes
1 answer
36 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 ...
user avatar
-1 votes
1 answer
136 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/...
user avatar
0 votes
1 answer
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 ...
user avatar
1 vote
1 answer
901 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: ...
user avatar
0 votes
1 answer
854 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 ...
user avatar