How can I access data in Excel from another worksheet based on local reference.
I need only the value of each arquivo.xls G13
I have three files with the following names.
1112.xls
1113.xls
1114.xls
I have the 4th folder that is trabalhho dados.xls
Column A have the information you want to use as a reference within the formula to indicate the name of the file that contains the value I need.
1112
1113
1114
Example: = 'D: \ Documents - Projects \ Projects \ Phase 2 \ Phase 2-1 \ ["& A1 &". Xls.xls] Folhas_02'! $ G $ 13
There are dozens of files, how can I get information on all of them.
Bookmarks