40 - Get Files Names from a Folder Based on User Selection in Excel using Power Query

[@luislopez-g2k]

Practically a Genius!

[@andriikulishov3371]

Excellent explanation!

[@manthanpanse1]

Thank You. This works well

[@trumpexcel]

Glad it worked 😃

[@margad-erdeneboldbaatar4704]

Thanks a lot.

[@FRANKWHITE1996]

Great video 🙌🙌🙌🙌

[@comp5434]

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]

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]

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)