1

I have a system set up in Google Sheets that, from an input produces an output in 'Mover'!K2:V, and that output has to be copied and pasted 'values only' to the bottom of a list on another sheet 'Sheet name'. After that I replace the old input with the new one, and the process repeats. I currently have a hyperlink that positions you exactly where you need to be placed to paste, and it is working. =HYPERLINK("SHEETADDRESS"&range=A"&COUNTA('Sheet name'!A:A)+1,"Placement")

Other people, some of whom are not familiar with Google Sheets at all, will use this system and I'd like to 'foolproof' the system as best I can by setting up an apps script button to copy and paste the range 'values only' with just a click. However I am not too familiar with apps script, so I'm not quite sure how to do it. Is it possible and if so how?

For example, if I were to do one right now, I'd be pasting into a range with 'Sheet name'!A1089 at the top left corner, but if I pasted 3 rows of data into there, the next one would be pasted into 'Sheet name'!A1092. (the number of rows pasted each time is not consistent).


I also have a similar range with a similar current setup, that is also working, but this time we are pasting to one sheet at random from of a range of 18 sheets. I have the sheet name that I want to paste to, automatically generated by functions from the input, in 'Mover'!A2. Is there a way to adjust the apps script from the last situation to handle that? (The range would be the same on every sheet, but the next empty row in that range would not.)

1 Answer 1

0

From the question

However I am not too familiar with apps script, so I'm not quite sure how to do it. Is it possible and if so how?

Start by reading https://developers.google.com/apps-script/guides/sheets

You will learn, among other things, that Google Apps Script uses JavaScript as the programming language, that it uses Class SpreadsheetApp, and that handling arrays in JavaScript is very common.

You should also get familiar with Google Sheets terms like cell, range, and data range, among other concepts.

Related

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.