40 - Get Files Names from a Folder Based on User Selection in Excel using Power Query
Рет қаралды 16,418
Күн бұрынIn this video, I will show you how you can get all the file names based on what folder you have selected.
Suppose you have multiple folders that keep getting updated with new files, you can create a drop-down with the names of the folders and use the technique shown in this video to get all the file names when you make a selection from the drop-down
✅ Power Query Course Download files: bit.ly/power-query-download
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzfaq.info...
#Excel #ExcelTips #ExcelTutorial
@user-iw6tq9nq9h Жыл бұрын
Practically a Genius!
@andriikulishov3371 3 жыл бұрын
Excellent explanation!
@FRANKWHITE1996 2 жыл бұрын
Great video 🙌🙌🙌🙌
@margad-erdeneboldbaatar4704 2 жыл бұрын
Thanks a lot.
@comp5434 4 жыл бұрын
What if the table thats being updated is not in the same sheet but in a different Sheet. Also what if after a single input from user in a cell, I have to Refresh multiple sheets based on the input. Where do I change the code for that and what changes need to be made? And the last and the most general case, What if I need to take multiple inputs from user, which in turn also changes a few other parameters in some other cells and then I have to use all these things to Refresh my table. Can it be done using macros??
@abhishekrajbhar9930 4 ай бұрын
Practice file for this lecture is not available in Zip file. After folder number 39 there is 41 and not 40. Please provide the file for practice.
@trumpexcel 4 ай бұрын
Sorry for the issue... I will fix all the download files in a couple of days (away from my system for the next 2 days)
Garena Free Fire Global
Рет қаралды 50 МЛН
Goodly
Рет қаралды 43 М.