Manuel1435
New Member
- Joined
- May 21, 2018
- Messages
- 1
Hi guys,
Great forum, I found many answers of great help here
. I now have one issue which I can't find a way around it:
In one cell I have:
='https://www.[..]/[MBSS_DATA_OCT17.xlsx]Table 10.2'!$C$18
Which gives me the value on cell C18 of that online excel file called "MBSS_DATA_OCT17.xlsx". This one works fine.
But I would like this formula to change the part "OCT17" for whichever value on another cell (lets say D8)
I have tried many ways and none of them works:
='"https://www.[..]/[MBSS_DATA_"&D8&".xlsx]Table 10.2"'!$C$18
Many thanks in advance!
Manu
Great forum, I found many answers of great help here
. I now have one issue which I can't find a way around it:In one cell I have:
='https://www.[..]/[MBSS_DATA_OCT17.xlsx]Table 10.2'!$C$18
Which gives me the value on cell C18 of that online excel file called "MBSS_DATA_OCT17.xlsx". This one works fine.
But I would like this formula to change the part "OCT17" for whichever value on another cell (lets say D8)
I have tried many ways and none of them works
:='"https://www.[..]/[MBSS_DATA_"&D8&".xlsx]Table 10.2"'!$C$18
Many thanks in advance!
Manu
