Example of consolidating excel workbooks
I have three datasets here, Q1, Q2, Q3, they all have a similar shape, and that they have names down the left hand side, months going across the top, but not exactly the same shape.
Q1 has Jan-Feb-Mar, Q2 has 5 months, I guess we got lazy and didn't figure out to do this at the end of June and someone finally did it at the end of August, and then Q4 has 4 months.
The results are great, but A1 is blank, column A is not sorted, and there's blanks in the data, use Go To Special Blanks, type a 0, Ctrl Enter to fill those blanks.
And then that final example there, consolidate can point to external workbooks, might be useful!
Alright hey, I want to thank for stopping by, we'll see you next time for another netcast from Mr Excel!
I got a call from a friend who wanted to combine multiple Excel files into one Excel workbook.
This is a great feature, but here's the things that just hacked me off.Alright, check this box for Use labels in the Top row and the Left column, that Browse button means that these data sets can be in different workbooks!Create links to source data, we're going to talk about that one at the end.Alright, first thing, it looks like it gave us the results, it did give us the results, but there's an extra column B here, and we have Group and Outline. So ideally, what you would have is, you'd have one workbook called January, and another workbook called February, and it's going to show you here's January, here's February.Here's the total for Mike Seeley, these are formulas pointing into those sales, and then here's a sum of those two, alright, it's weird.