Consolidate and Combine Data in Excel Between Multiple Workbooks
Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.
Learn how to consolidate information from multiple different excel workbooks into one excel workbook. This allows you to add similar information together from many different sources.
This video tutorial shows you how to consolidate inventory lists for parts from multiple stores or sections from one company and then display the consolidated or summed data in one main spreadsheet. Also, you will learn how to create links to the source data so that whenever the source data updates, your main spreadsheet will also update. This talks about the data consolidation feature and linking in Microsoft Excel 2007.
For Excel consulting or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.
Have a great day!
Channel: Education
Uploaded: November 30, 1999 at 12:00 am
Author: ExcelisHell
Length: 09:05
Rating: 5.0
Views: 3733
Tags: microsoft excel 2007 excel help excel guides video tutorials excel consulting excel tips tricks learn excel excel teacher useful hints in excel teach me excel need to learn to use excel add similar values in excel data tools in excel manipulate data combine data sources in excel consolidate information from multiple files in excel many different workbooks
Video Comments
|
