Forum Discussion
"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...
HI Dalius,
it may be worth you looking into Power Query to do this sort of data consolidation.
What version of Excel are you using?
How many files and how many rows / columns are you referencing?
it may be worth you looking into Power Query to do this sort of data consolidation.
What version of Excel are you using?
How many files and how many rows / columns are you referencing?
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).