✅ Download the file | www.exceleinfo....
🏆 Subscribe | goo.gl/M5zNA8
In Chapter 6 of this series, Learn Power Query for Excel, we saw how to consolidate information from several Excel files contained in a folder into one and then make a dynamic table with the information of all the files.
Adding new files to the folder
The surprising thing about Power Query is that with the right steps, virtually the queries are made automatically, and for this example is not the exception. Consolidating information from several Excel files implies that all the files contained in a folder will be consolidated in a Master Table, even if you later add new files to the folder they will be added to the query with just refresh.
More examples | www.exceleinfo.com
More examples | blogs.itpro.es/...
Facebook Page | / exceleinfo
Get notificacions on Telegram | t.me/EXCELeINFO
Twitter | @EXCELeINFO
Twitter | @SergioACamposH
Download EXCELeINFO addin:
addin.exceleinf...
16 сен 2024