Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
108
Views
Topic starter
Hi
i am finding this training very helpful but do you have a short video of combining multiple workbooks from separate folders rather than combining multiple tabs in one workbook?
Posted : 26/10/2022 5:38 am
Hi Dan,
You can combine all or select workbooks in a single folder, or you can combine all or select sheets in a single file. However, if you want to combine multiple files from multiple folders then you'd need to create a query for each folder and then Append those queries together to create one table.
Hope that clarifies things, but please come back if anything isn't clear.
Mynda
Posted : 26/10/2022 7:31 am
Topic starter
Thanks, this helps. let me take a look.
Posted : 26/10/2022 8:25 am
