How to get data from the most recent file in a Folder with Power Query in Excel

Опубликовано: 31 Октябрь 2024
на канале: Celia Alves - Solve & Excel

17,108

140

Learn how to get data from the most recent file in a Folder with Power Query in Excel. The next time you need to update your report, you just need to place your new data file in that folder and refresh your queries.

________________________________________________________
Learn how to AUTOMATE YOUR EXCEL REPORTS in minutes instead of hours without copy-paste or coding: https://snapreportschamp.com/course

Get this ready-to-use Excel solution for 2 and 3 columns of Dependent Dropdown Lists:
https://solveandexcel.ca/dynamic-depe...
___________________________________________________________________

My Contact information:
Celia Alves - Microsoft MVP & Certified Excel Expert, Solutions Developer
Solve & Excel Consulting - https://solveandexcel.ca/
LinkedIn: / celiajordaoalves
Facebook: / solveandexcel
Twitter: @celia_excel
Instagram: @solveandexcel

--------------------------
Learn Excel and connect with a community of Excel professionals and enthusiasts:
MS Excel Toronto Meetup Group - https://www.meetup.com/MSExcelToronto/

Learn how to automate your Excel Reports: https://snapreportschamp.com/

#Excel #solveandexcel #microsoft365 #toronto #torontobusiness #mvpbuz #communityrocks #wit