Consolidating Data from Multiple Excel Worksheets By Position
You can quickly summarize the data contained in multiple
Excel worksheets by using
the Data Consolidation tool. It does not require a complicated formula. You can, if you wish create a link to the source data. However, if you are not careful, it is easy to "double" your totals.
Watch as I show you how to avoid this embarrassing
error. I also show you how to quickly create formulas that total values from multiple Excel worksheets.
This is one of the tips available on my
DVD, "The 50
Best Tips for
Excel 2007." I invite you to visit my website - www.thecompanyrocks.com - to learn more about the resources that I offer.