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, Wyn,
Can You tell me more about Power Query?
I use Excel 2013.
At the monet i think there could be 12 columns. Rows number is equal to source files number, and it is hard to say but do not think that there wil be more then twenty (20).
Wyn Hopkins
Jun 19, 2017MVP
Hi Dalius
You can download Power Query here
https://www.microsoft.com/en-au/download/details.aspx?id=39379
Here's a demo of how it can be used
http://myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-query/