Get cell value into text

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I'm having trouble to get an automatic update of filename in function
='[Time_report_August.xlsm]Time report'!$AH$20
I want to read the August part in the filename from a cell in order to be able to have this dynamically changeable.
How should I do?

BR
M

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
So are you saying that you want to build this "Time_report_August.xlsm" string dynamically and then excel evaluate it to you the result. In that case you have to use address and indirect functions, I would imagine