Question Regarding take function

[xaikus506]

Hi, I am trying to get the data from a sharepoint excel file to a local excel file (located in my laptop). I tried to use the "Take" function with the data on the sharepoint folder with counta and it works. However, the syntax is too long because of the URL from the sharepoint link has too many folders that I cannot restructure because of company rules. My question is is there a way to shorten the syntax of my "Take" function by using cell referencing as shown in the image? and I need it to work even if the excel file is close. Thanks.

 

[Fluff]

If the other workbook is closed then you will need to stick with what you've got.

 

[xaikus506]

If the other workbook is closed then you will need to stick with what you've got.

Thanks!

 

[Fluff]

You're welcome.