CODEWITHSUNDEEP
excelexcel-formulahyperlinkexcel-2010
Sofus1970
Sofus1970

Reputation: 1

Excel formula with link to URL adresse an specific cell value

Hi #Excel specialists

I have a problem I'm trying to solve but I can not fix it myself.

I have a workbook we can call WORKBOOK 1 where I want to get a value from another workbook on Sharepoint to show in the cell with the formula I'm trying to write.

The URL link to Sharepoint I will type into a cell as a fixed link and use in the formula to get the cell value from another workbook we can call WORKBOOK 2

Example:

Workbook 1 is where I want to show the cell value from Workbook 2 (where workbook 2 are on Sharepont). In workbook 1, I have the URL address to workbook 2 in sheet 2 cell A1.

In workbook 2 the cell value shall be taken from Sheet 1 cell G1

Hope this makes sense and someone can help me.

I have been trying to use the statement "HYPERLINK"

=HYPERLINK("#' & "sheet2" & "'A1" & "[FILE1.XLSM]Sheet1'" & G1")

URL example to Sharepoint 1 workbook 1 sheet 2 cell A1 https://mytestsite.sharepoint.com/

Upvotes: 0

Views: 38

Answers (0)

Related Questions