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.
- Get the file list using GetAllFiles
- Setup the import via the UI for DataFromExcel on a single file.
- Modify the formula to link to all files via RegionDown.SK