Forum Discussion

Dalius J.'s avatar
Dalius J.
Copper Contributor
Jun 16, 2017

"mother" cells linking with "source" files in excel

Hi, will try to describe the problem that i met in excel

There is a "Mother" file which collects data from several source files. Source files has the same structure and data always filled in the same way, same cells (for example if we have File1.xlsx and File2.xlsx and ... then cell C1 in all files has the same meaning but not the same value)

Now in Mother file in A1 i enter name "File1.xlsx" and then in B1 should apear value from File1.xls tab "sheet1" cell C1. If it would be done manualy formula would look like:

=+'[File1.xlsx]sheet1'!$C$1

In Mother file in A2 i enter name "File2.xlsx" and then in B2 should appear value from File2.xls tab "sheet1" cell C1. If it would be done manualy formula would look like:

=+'[File2.xlsx]sheet1'!$C$1

Question: is it possible  to write simple formula that "[File1.xlsx]" part would be taken from Mother file A1 and then linked to correct cell in source file.

 

BR

DJ

6 Replies