Hi guys,
there is possible to read a value from cell where I put the name of sourcefile as "string" and naming that cell then use name of cell in formula excel?
for example:
as you see, the first table is working but before I run macro without choosing manually that file I need to put in on for example Mapped drive/sharedrive etc.
The next table is not working = always need to choose manually file, even if its opened in excel or in the same folder.
Want to add - In another IF(ISERROR(VLOOKUP(INDIRECT) example its working. What is wrong?
there is possible to read a value from cell where I put the name of sourcefile as "string" and naming that cell then use name of cell in formula excel?
for example:

as you see, the first table is working but before I run macro without choosing manually that file I need to put in on for example Mapped drive/sharedrive etc.
The next table is not working = always need to choose manually file, even if its opened in excel or in the same folder.
Want to add - In another IF(ISERROR(VLOOKUP(INDIRECT) example its working. What is wrong?