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 ...
SergeiBaklan and nabilmourad,
Thanks for your replies!
So if make a template file with all the columns and headers that will be there in the end, it will add null data to columns where there is no data and add the data it has to the appropriate column?
For instance if I make a table template that looks like this:
| Col A | Col B | Col C | Col D | Col E | Col F | Col G |
And my first worksheet looked like this:
| Col A | Col B | Col D | Col E | Col F |
| abc | abc | abc | abc | abc |
And a second looked like this:
| Col A | Col B | Col C | Col E | Col G |
| abc | abc | abc | abc | abc |
I would get an output like this?
| Col A | Col B | Col C | Col D | Col E | Col F | Col G |
| abc | abc | abc | abc | abc | ||
| abc | abc | abc | abc | abc |
And if so, would it matter if the columns weren't necessarily in the same order as long as they had the same headers?
Cheers,
Brian
Hi Brian,
Yes, practically. Initial result will be as
After filtering the template file and removing first column
You may add as many files as needed into the folder