Questions tagged [google-sheets-macro]
The google-sheets-macro tag has no usage guidance.
25
questions
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 = ...
- 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 &...
- 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 ...
- 1,188
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 ...
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 = 発注書)
...
- 3
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 ...
- 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 + ...
- 1
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 ...
- 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 ...
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 ...
- 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:...
user1377159
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 ...
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 ...
- 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 ...
- 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 ...
- 1
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 ...
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?
- 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 ...
- 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 ...
- 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, ...
- 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 ...
-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/...
- 7
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 ...
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:
...
- 688
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 ...
