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.