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!

Have a look at the INDIRECT function

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for your reply!