Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [google-sheets-macro]

The tag has no usage guidance.

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

Macro to return 1 + the value of the cell above

I am experienced with VBA but not Google Apps Script / Javascript. I'm doing a lot of data entry for which filling down with CTRL+D is super-useful but I want to create a macro that will copy down the ...
Daniel Austin's user avatar
1 vote
1 answer
58 views

Recorded a Macro to Import a File in Google Sheets

I'm able to import a file from my disk using "File Import". I tried to do the process while recording a macro. I did "File", "Import", then chose "Upload new file&...
NealWalters's user avatar
-1 votes
2 answers
214 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
169 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,754
2 votes
1 answer
96 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
70 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
788 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
  • 302
1 vote
1 answer
869 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
487 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
137 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
406 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
1 vote
1 answer
236 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
  • 13
0 votes
1 answer
481 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
912 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
2 votes
1 answer
48 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
2 votes
0 answers
152 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
2 votes
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
  • 21
0 votes
1 answer
288 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
1 vote
1 answer
855 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
  • 13
0 votes
2 answers
1k 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
3 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
  • 31
-1 votes
1 answer
43 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
295 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
2 votes
1 answer
2k views

How can I avoid being prompted to authorize macro-enabled spreadsheets from trusted users?

When I try to open a new macro-enabled spreadsheet, Sheets prompts me to provide authorization even though: The owner of the document and I are part of the same Google Workspace organization. I have ...
Ediz Mudul's user avatar
2 votes
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
944 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