Consolidate Data from Multiple Excel Workhseets Part 2
In Part One, I showed you how to Consolidate Data By Position - where the range of cells was consistent in each of the Excel worksheets - Click on this link to go to this lesson.
Consolidate Data By Category
In this lesson, I show you how to Consolidate Data By Category / By Label. You use this technique when the number of rows or columns containing values varies from worksheet to worksheet. For example, the number of sales representatives reporting may change each month. Or, some of the worksheets that you receive contain an extra column that you want to include in your consolidation. Consolidating Data by Category is very flexible as you will see in this lesson.
Learn how to “Master Excel in Minutes – Not Months!”
Consolidate Data from Multiple Excel Worksheets By Category [ 5:35 ] Play Now | Play in Popup | Download (408)
August 26th, 2010 at 6:06 AM
[...] I continue this lesson on Data Consolidation in Part Two. Click on this link to see how to Consolidate Data By Category. [...]