Dynamic linkage to file

[Didieeer]

Hi all,

Not sure if I'd better post this here or in the tutorial forum, as I'm actually looking for an example function/script or a tutorial.

Situation of my problem.

Folder structure:

- main folder
main.xlsx
-> subfolder
001_file.xlsx
002_file.xlsx
003_file.xlsx
...

001_file.xlsx (and actually any other file from the subfolder but with different data)

	1	2
A	Name	Patrick
B	Age	40

main.xsx

	1	2
A	Code	001
B	Name	Patrick
C	Age	40

How it should be:
If I type "001" in A2 (marked red) of main.xlsx it should get the data from /subfolder/001_file.xlsx to complete B2 and C2 (marked blue), if I type "002" it should search in the "002_file.xlsx" of that subfolder. Etc etc.

Any suggestions or examples?

Thanks in advance!

[Didieeer]

Little first bump.

If needed I could make my example with actual excel-files.

Thanks.