The formula below can get the value of A1 of File A and File B:
='C:\Users\DK-01\Desktop\[File A.xlsx]Sheet1'!$A$1
='C:\Users\DK-01\Desktop\[File B.xlsx]Sheet1'!$A$1
Now the value of Cell A1 and A2 is File A and File B respectively.
How to revise the dynamic link at Cell B1 and B2 to get the value of cell A1 at File A and B:
"='C:\Users\DK-01\Desktop\["&A1&".xlsx]Sheet1'!$A$1"
"='C:\Users\DK-01\Desktop\["&B1&".xlsx]Sheet1'!$A$1"
Bookmarks