Forum Discussion
Combining multiple quarterly workbooks into one master workbook.
Hi all, I get quarterly excel files that I have been manually combining and I am wondering if there is a more efficient way that I can be doing it with less chance of user error? Each quarter I ...
Thanks for posting the files. Unfortunately I don't have access to my C:/ drive... Will it work if I put it in my z:/ drive? Or would the code need to be changed?
Cheers,
Brian
Brian, I added the parameter to the attached file.
When you start with Power Query most probably you'll see the warning what your version could be incompatible with queries - ignore it.
Open right pane with queries (Data-> double clink on Queries and Connections). It shall be like
Double click on pFilePath and change it on yours. Now double click on Test and Refresh it. Before that ignore all errors.
Group of queries under Transform... is generated automatically, you query is only Test.