The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [google-sheets-macro]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
43 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
1answer
24 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 ...
0
votes
1answer
14 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
0answers
45 views

Google Sheet - auto copy once a day a value from a row to another row in another sheet

I have a Google spreadsheet that is being modified during the day, and need to copy and paste the final information of a row in a different row in a different tab, each day, pasting the new ...
1
vote
1answer
68 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 ...
0
votes
0answers
26 views

How to copy cells (relative) and paste into an absolute cell location in Google Sheets

Trying to create a function where I can copy an entire block of cells depending location of button where script is activated (getting them to select works fine): spreadsheet.getCurrentCell().offset(-...
0
votes
0answers
10 views

sheet date copy

When you run a macro from the "A" sheet, you need a script that pastes the data from "A1:C1" to the "B" sheet "A:C". We want data to be stacked in a blank space every time we run a macro, whether it's ...
0
votes
0answers
12 views

Add one column after E column in all sheets [duplicate]

any ideas how can I add a Column after a determinate column in all sheets in one time?
1
vote
1answer
260 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
1answer
457 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 ...