I'm trying to consolidate individual spreadsheet tabs across multiple spreadsheets into one master sheet that collects all the data for analysis.
Google Sheets has this formula that will display the selected criteria: =ARRAYFORMULA(IMPORTRANGE("Spreadsheet URL","Tab Name!A1:J29")). That formula is entered into 1 cell, and it displays everything in the selected data range across the equivelent number of cells in the new spreadsheet.
Original Data Link: https://drive.google.com/open?id=1yy...J4b2LxZio7XqI4
Consolidated Data Link:https://drive.google.com/open?id=1wX...21WHq7ZMpwZH_0
Does excel have an equivalent option? All files would be saved in the same server folder.
Bookmarks