EHP
New Member
- Joined
- Jul 12, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi
I have a cell within a spreadsheet, that references a different spreadsheet (see bottom for examples)
Is there a way to create a formula so that I don't have to either enter each address manually or copy & paste. I tend to find errors with these two methods. Due to security restrictions I cannot use Macros.
From the example below, I am using two spreadsheets, accessing different cells within different tabs.
Cell A1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet1'!$D$7
Cell B1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet1'!$D$9
Cell C1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet2'!$J$107
Cell D1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet2'!$A$88
Cell A2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet1'!$D$7
Cell B2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet1'!$D$9
Cell C2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet2'!$J$107
Cell D2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet2'!$A$88
Hopefully this makes sense.
EHP
I have a cell within a spreadsheet, that references a different spreadsheet (see bottom for examples)
Is there a way to create a formula so that I don't have to either enter each address manually or copy & paste. I tend to find errors with these two methods. Due to security restrictions I cannot use Macros.
From the example below, I am using two spreadsheets, accessing different cells within different tabs.
Cell A1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet1'!$D$7
Cell B1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet1'!$D$9
Cell C1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet2'!$J$107
Cell D1 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Filename.xlsx]Sheet2'!$A$88
Cell A2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet1'!$D$7
Cell B2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet1'!$D$9
Cell C2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet2'!$J$107
Cell D2 : ='https://sharepoint.location.com/folder1/subfolder/Finance/[Another_Filename.xlsx]Sheet2'!$A$88
Hopefully this makes sense.
EHP