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 sam...
Formulas & Functions
Need Help
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jun 16, 2017

Hello Dalius

 

It is possible. You need INDIRECT(). INDIRECT() requires the source files to be open.

 

  • Dalius J.'s avatar
    Dalius J.
    Copper Contributor
    Jun 18, 2017

    Hi, Detlef, 

     

    I would prefer that data would be taken when source file is also closed :)

    I tried INDIRECT() function but i did not like how it worked.

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Jun 19, 2017

      Hi Dalius

       

      Then don't bother with INDIRECT().