Hi guys, appreciate any help please.
The File Name inserted at B1
I would like a formula in B2 to look into the File "11111111 GEB25 Trial 1" and return the value in Cell AJ17
If I would enter the formula/link manually it would be ='[11111111 GEB25 Trial 1.xlsm]Work Book'!AJ17
However, I would like the formula in B2 to return the above formula whatever the file name value in B1 is.
Thank you
Bostiao
The File Name inserted at B1
I would like a formula in B2 to look into the File "11111111 GEB25 Trial 1" and return the value in Cell AJ17
If I would enter the formula/link manually it would be ='[11111111 GEB25 Trial 1.xlsm]Work Book'!AJ17
However, I would like the formula in B2 to return the above formula whatever the file name value in B1 is.
Thank you
Bostiao