Get data from the last file in a folder with Power Query Excel Off The Grid

Home › Other Content › Get data from the last file in a folder with Power Query Excel Off The Grid

Channel: Excel Off The Grid • Sourced: Youtube • Published 7 months ago

Do you want to automate Excel? Discover our training academy
https://exceloffthegrid.com/academy

Check out the blog post for more details
https://exceloffthegrid.com/data-latest-file-power-query/

About this video
Our ability to efficiently manage input is essential to creating automated processes in Excel. A common reporting scenario is to get data from the latest file. This usually happens when each file includes historical data; therefore we only need the latest file.

In this video, we explore how to create an effective solution to this situation.

00:00 Presentation
0:16 Connect to folder
0:55 Fields available to identify the latest file
2:17 Steps to access the latest file
3:34 Test the solution
4:08Conclusion

Download the FREE ebook of the 30 most useful Excel VBA macros
https://exceloffthegrid.com/

Where to find Excel off network
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid

#MrsExcel