★ Want to automate Excel? Check out our training academy ★
exceloffthegrid.com/academy
★ Check out the blog post for more details ★
exceloffthegrid.com/data-late...
★ About this video ★
Our ability to manage inputs effectively is critical to building automated processes in Excel. A common reporting scenario is to get data from the latest file. This generally occurs where each file includes the historical data; therefore, we only need the latest file.
In thisvideo, we are exploring how to create an efficient solution for this situation.
0:00 Introduction
0:16 Connect to folder
0:55 Available fields to identify the latest file
2:17 Steps to get to the latest file
3:34 Testing the solution
4:08 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel
6 авг 2024