Need help using user input to perform query



I haven’t really used any advanced features of Excel and I’m stuck on how to do this:

(Using Excel 2016)


I would like to use user input cells to determine which folder to pull data from using a power query. The data is pulled from a folder which is determined by the user.

Is there a way to do this?

For example: if the user wants to pull data from folder “Test2” then all they have to do is enter this into an excel cell and the workbook will display the formatted data from that file.

By: Ana Li

Leave a Reply

Your email address will not be published. Required fields are marked *