Questions tagged [google-sheets-macro]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-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 ...
bcknblf's user avatar
-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 ...
nic's user avatar
  • 8,714
-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 > ...
Kamalnayan Vyas's user avatar
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 ...
Lauren Andrews's user avatar
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 ...
john moore's user avatar
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 = ...
Jacktose's user avatar
  • 272
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 ...
Lasse V. Karlsen's user avatar
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 = 発注書) ...
Cristina's user avatar
-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 ...
Josh's user avatar
  • 1
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 + ...
aishlia's user avatar
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 ...
Badger's user avatar
  • 3
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 ...
Rob Holliday's user avatar
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 ...
Midavalo's user avatar
  • 149
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:...
user avatar
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 ...
Abyssal Spark's user avatar
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 ...
Luca's user avatar
  • 1
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 ...
Rob's user avatar
  • 11
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 ...
Glimpsed's user avatar
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 ...
EBDC's user avatar
  • 3
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 ...
zipzit's user avatar
  • 101
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, ...
Othello's user avatar
  • 21
-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 ...
Jason John Abraham's user avatar
-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/...
c hecker's user avatar
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 ...
Ediz Mudul's user avatar
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: ...
Skeleton Bow's user avatar
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 ...
Dijkgraaf's user avatar