austinghamilton
New Member
- Joined
- Sep 15, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
I need help creating a dynamic file reference in Excel (Please let me know the correct terminology as well). Currently, it is
"='[SDR2021_AFG_NN.xls]Forecast NN 29 -- T5B5 -- AFG'!C2"
I want to do something like this:
"='[SDR2021_$P$94_NN.xls]Forecast NN 29 -- T5B5 -- $P$94'!C2"
In cell P94, in the same sheet as the formula, I have entered "AFG".
Please advise.
"='[SDR2021_AFG_NN.xls]Forecast NN 29 -- T5B5 -- AFG'!C2"
I want to do something like this:
"='[SDR2021_$P$94_NN.xls]Forecast NN 29 -- T5B5 -- $P$94'!C2"
In cell P94, in the same sheet as the formula, I have entered "AFG".
Please advise.