Forum Discussion
Combine data from multiple excel workbooks in a folder into one master file
I use Office 365 Hello, Please note that I made few changes to the criteria and the files that correspond to the new changes. I need help with VBA code that need to perform the below: There...
I believe you need to work with structured tables. In all four files, I formatted each of the data ranges to an Excel table called "Table1". It should like something like this:
Then you can connect PQ to the Reports folder and pick-up Table1 from each file. Make sure that you select report 4 as the sample file. PQ defaults to the first file in the folder. If that one has fewer columns than later ones the new columns will not be picked up.
The attached file should work for you provided you create the tables as mentioned above.
I have over 100 files that I would need to work to apply the structured tables to. Looks like a VBA approach is a better solution here.