Forum Discussion
Dalius J.
Jun 16, 2017Copper Contributor
"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...
Dalius J.
Jun 18, 2017Copper Contributor
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
Jun 19, 2017Silver Contributor
Hi Dalius
Then don't bother with INDIRECT().