In this Microsoft Excel video tutorial I demonstrate how to combine multiple workbooks (stored in the same folder) in a single workbook. The method shown in this video uses Power Query.
Click here to download the featured files.
Video Table of Contents
00:00 – Introduction
00:15 – Create a ‘From Folder’ query in Power Query
00:37 – Exclude non-Excel files
01:47 – Apply data transformations
05:47 – Edit the query
06:18 – Add more workbooks to folder and update data in the combined file