Questions tagged [google-sheets-macro]
The google-sheets-macro tag has no usage guidance.
27
questions
-1
votes
1
answer
29
views
How to refresh a single cell in google sheet
I wanted a solution for single cell refresh in google sheets.
Searched in here and got an excellent solution.
" 1. Select the cell you want updated.
2. Delete the cell.
3. Undo with Edit > ...
1
vote
1
answer
61
views
Timed Triggers for Macros on Multiple Sheets in a Spread Sheet
I'm trying to make a student signout sheet for a whole school. We have one main spreadsheet but multiple separate sheets within that (one for each homeroom, about 25 homerooms so 25 sheets). I created ...
1
vote
1
answer
21
views
Google Sheets Line Height issue after form submission
I need my row height in google sheets to stay at 40.
The issue I am having is every time a user submits a form and a new entry is created, the line height goes back to the original formatting.
I ...
0
votes
1
answer
396
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 = ...
0
votes
0
answers
17
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 &...
0
votes
1
answer
278
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 ...
0
votes
0
answers
126
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
336
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 = 発注書)
...
0
votes
1
answer
60
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 ...
0
votes
1
answer
157
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 + ...
0
votes
1
answer
102
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 ...
0
votes
1
answer
77
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
382
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 ...
1
vote
2
answers
37
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:...
1
vote
0
answers
92
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
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 ...
1
vote
1
answer
206
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
1
answer
166
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
1
answer
733
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
2
answers
897
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 ...
2
votes
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, ...
-1
votes
1
answer
38
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
200
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
1
answer
2k
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
1k
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
1
answer
898
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 ...