Questions tagged [google-sheets-macro]
The google-sheets-macro tag has no usage guidance.
26
questions
-1
votes
2
answers
127
views
Google apps script or formula to solve convert to proper case, with exceptions
CLARIFICATION: I asked for a script because there are some other things I'm doing as well and I figured I would combine them all in a single script. But if a formula is the best way to do it, I can ...
-1
votes
1
answer
70
views
Run existing macro on a new Google Sheet with least number of clicks
How to execute an existing macro (or any other kind of script) on a new Google Sheet with the least number of clicks/keystrokes?
Or even automatically when opening it?
Context: My bank sends me a new ...
-1
votes
1
answer
227
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
82
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
49
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
656
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 = ...
1
vote
1
answer
643
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
1
answer
436
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 = 発注書)
...
-1
votes
1
answer
112
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
303
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
177
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
196
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
648
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
1
answer
45
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
122
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
28
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
2k
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
1
answer
265
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
800
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
978
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
2k
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
42
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
265
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/...
1
vote
1
answer
2k
views
How can I disable the authorization needed to open Google Sheets Macros? [closed]
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
932
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 ...