you have no idea how long i searched for this exact thing!!!! Thank you so much!

Great! It helps a lot to get the idea! Thanks

Tks for the video! I would like very much watching more and more Office Scripts videos

@ExcelGoogleSheets

2 жыл бұрын

🙂

@aa2lo060

Жыл бұрын

@@ExcelGoogleSheets Me too

Thank you.

Greetings from Colombia!! Thanks!!!

Excellent tutorial, thanks!! Can you please explain how how obtain the row number of the selected cell??

👍

@ExcelGoogleSheets

2 жыл бұрын

Thanks!

Hello, firstly thank you so much. My question: I am trying to copy and paste a value from the same sheet but to a different cell. I understand that you are using static values such as ["Line 5"...]. For example, every week my cell C26 changes, I want to copy and paste that value to B51 (my last row), then the following week copy C26 to B52 with an expanding table. Do you have an idea on how to do that?

@ExcelGoogleSheets

Жыл бұрын

Just make a script the same way I did in the video by grabbing the value from C26 and then schedule that script in power automate to run weekly.

Question: Do you believe other applications like Word or Powerpoint will get Office Script support? Google App Script is fantastic, but seems as though Microsoft is not fully committed to making full-fledge alternative to App Script.

@ExcelGoogleSheets

2 жыл бұрын

I have no clue. App Script has it's limitations too, it's not like it's perfect. The only thing I know is that within the last couple of years there were a lot of updates done by Microsoft. I can't say the same about Google, it's snail pace.

hi sir , i want to ask how do we reach the last used row of a desired column?

how about Repeated item labels?

Hello Sir, I have a query regarding Google finance please help me to solve it. Query is, I have 25 stocks list in Column B and I want in column C or D is ( specific date closing price of every stocks of collum B. Like I want 23/6/2022 closing price in column C or D)

Hi, thank you for the video. I get an error on line 5 : Cannot read properties of undefined (reading 'getUsedRange'). Mine are pivot tables on a sheet I need to find the upper and lower range for further automation. Can you please help?

@ExcelGoogleSheets

Жыл бұрын

You can use Ctrl+Up, Ctrl+Down shortcuts to figure out the start and end. learn.microsoft.com/en-us/javascript/api/office-scripts/excelscript/excelscript.keyboarddirection?view=office-scripts

@sabarashid1513

Жыл бұрын

@@ExcelGoogleSheets Thank you for the prompt response. Looking forward to more videos around Office Script from you :-)

ca you do more guidance video on excel office script?

@ExcelGoogleSheets

Жыл бұрын

Did you watch these already? kzread.infosearch?query=office%20script

Hello may i ask some help? I need fix that if other user edit some cell and hit enter, then the dropdown menu that i open or other user open will be closed. Why it's happening? Edit: i guest the autosave from google sheet that caused the dropdown closed after other user edit cell. The question is how to avoid the automatic save from google sheet?

@ExcelGoogleSheets

2 жыл бұрын

What do you mean by "dropdown menu"?

@PanduKm

2 жыл бұрын

@@ExcelGoogleSheets i mean the dropdown in the cell sir, when i open the dropdown it will immediately closed after other user edit any cell in any sheet, that's why i think the autosave from google sheet that caused the dropdown closed.

@ExcelGoogleSheets

2 жыл бұрын

@@PanduKm I don't think there is anything you can do.

@PanduKm

2 жыл бұрын

@@ExcelGoogleSheets okay sir thanks for answering my question. But could you create a tutorial for filtering or lookup data from another workbook but from app script? I try looking on Google but can't find that tutorial.

Hello sir, i need your help.I know only you can help me. my problem is whenever i am trying to append data it strarts from 1st column But i want to insert data from 3 or 4th column. How it is possible and what would be the source code of this problem. Please help me

@ExcelGoogleSheets

2 жыл бұрын

use setValues() instead of appendRow()