Multiple Workbooks

Input: Multiple Excel files with a single sheet of data.

Download sample input file here

Download all sample workbooks here

Goal: Setup a DataFromExcel formula that collates the data from all the workbooks and puts it in one single place.

Hint:

  1. Get the file list using GetAllFiles
  2. Setup the import via the UI for DataFromExcel on a single file.
  3. Modify the formula to link to all files via RegionDown.SK