This works:
='https://Construction Weekly Reports/[P02-WS.xlsx]2.4.12'!D$4
I would like to replace 2.4.12 with a cell reference (T1, which would contain "2.4.12" ...)
I know this does not work:
='https://Construction Weekly Reports/[P02-WS.xlsx]'T1!D$4
thank you for the help!
if it matters, the external excel sheet is in a sharepoint site...
='https://Construction Weekly Reports/[P02-WS.xlsx]2.4.12'!D$4
I would like to replace 2.4.12 with a cell reference (T1, which would contain "2.4.12" ...)
I know this does not work:
='https://Construction Weekly Reports/[P02-WS.xlsx]'T1!D$4
thank you for the help!
if it matters, the external excel sheet is in a sharepoint site...