Thread: [Solved] Import a nomefile contained in a cell into a formula contained in another cell (in the same sheet)
View Single Post
 
Old 03-04-2023, 10:19 AM
massimodfd massimodfd is offline Windows XP Office 2010 32bit
Novice
  
Join Date: Jan 2015
Posts: 29
massimodfd is on a distinguished road
Default Import a nomefile contained in a cell into a formula contained in another cell (in the same sheet)
Hallo All!
Could you please help me with this:
I have in cell A2 a formula:
='C:\Users\m.salerno\Documents\[Cost overview.xlsm]Financial'!$O47
This formula gives in cell A2 the content of the cell O47 in the sheet Financial of the file Cost overview.xlsm (that is a different file)

Is it possible to indicate the name of the file (because the file name can change) in the cell A1 and automatically the formula import the file name ?
I mean something like:

='C:\Users\m.salerno\Documents\[A1]Financial'!$O47
I tried but it doesn't work.

Thanks!
Reply With Quote