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 ...
Hi Brian
Although Power Query is doing magic, however, at the end it just repeats the same steps in the same sequence, assuming that you run the function to similar sources.
Also note that if you are recording among the steps, a step that keeps 3 columns and Deletes other columns >> so it will delete Other columns whether they are 5 or 6 or 7...
Once you get the concept, you apply it according to your work situation
Good Luck
Nabil Mourad