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.