by Wyn Hopkins

Power Query and a file selector Macro


     


     

    Power Query File Selector

     

    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

    Free Download

     

     

    As promised in the video here’s the method for referencing named cells and using them as parameters in Power Query.