by Wyn Hopkins
Power Query and a file selector Macro
If you have an Excel file containing Power Query and need to send it to colleagues, read on.
If they need to be able to change where the source data for the Query is being pulled from then read on.
If you want to make the process as simple as possible for them then watch this….
File Selector Macro Download
As promised in the video here’s the method for referencing named cells and using them as parameters in Power Query.