I would like to automate a spreadsheet using an app script. Copy data from one tab to another. Column D6:D10 to ("sheet1") to A4:E4 ("sheet2"), I tried several codes and I have failed. Can someone help me? Apparently it's simple, but I can't.
Asked
Active
Viewed 35 times
1
-
try: `=TRANSPOSE(sheet1!D6:D10)` – player0 Sep 24 '19 at 19:23
-
Thank you friend. But I wanted via app script because I'm using a button. – Icaro Lessa Dourado Sep 24 '19 at 20:04
-
Look here for a cool transpose: https://stackoverflow.com/a/16705104/7215091 – Cooper Sep 24 '19 at 22:44