Retrieve cell value from other workbooks
Solved
Thibault
-
Thibault -
Thibault -
Hello,
I want to retrieve values from cells located in different Excel files into one Excel file.
These files are in different folders. However, the cell is always located in the same place (same tab name and same cell).
I have entered the beginning of the file path in cell A1 and the changing part of the path in other cells (see the screenshot extract: https://www.cjoint.com/c/IGig4BOtf5k).
As I have quite a few values to retrieve this way (several values from multiple files), I would like a formula like: $A$1&Ai&\[file name.xlsx]Sheet'!$G$2.
I can't seem to find the right combination with the correct symbols in the right places.
I think there must be a solution with formulas. I would like to avoid using macros for this.
Thank you in advance for your help.
I want to retrieve values from cells located in different Excel files into one Excel file.
These files are in different folders. However, the cell is always located in the same place (same tab name and same cell).
I have entered the beginning of the file path in cell A1 and the changing part of the path in other cells (see the screenshot extract: https://www.cjoint.com/c/IGig4BOtf5k).
As I have quite a few values to retrieve this way (several values from multiple files), I would like a formula like: $A$1&Ai&\[file name.xlsx]Sheet'!$G$2.
I can't seem to find the right combination with the correct symbols in the right places.
I think there must be a solution with formulas. I would like to avoid using macros for this.
Thank you in advance for your help.
