I have currently 14 workbooks that I want to pull a few rows of data from each and consolidate in a master file. Currently I'm just using formulas linked to the workbooks to automatically update and pull the rows that I want., e.g.: ='T:\Data\WIP\[Test File 1.xlsx]Sheet1'!H$21
I've set it up for two files and it's pulling the data and updating in the master file okay however, the final storage location for these files are still TBD so I haven't set it up for all 12 files yet. I'm slightly concerned that it may get a bit laggy when I do (roughly 28 rows x 110 columns of linked cells over two worksheets in the master file) , not to mention requiring updating if the file locations if they are ever moved.
I was wondering if the data consolidate tool will be a faster way of consolidating the data or is there no difference?
I've set it up for two files and it's pulling the data and updating in the master file okay however, the final storage location for these files are still TBD so I haven't set it up for all 12 files yet. I'm slightly concerned that it may get a bit laggy when I do (roughly 28 rows x 110 columns of linked cells over two worksheets in the master file) , not to mention requiring updating if the file locations if they are ever moved.
I was wondering if the data consolidate tool will be a faster way of consolidating the data or is there no difference?