Visit www.TeachMsOffice.com formore, 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 There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel. Have a great day!
9 comments
No ping yet
gowingkw says:
January 28, 2012 at 3:08 pm (UTC 8)
i need help? also…
ExcelisHell says:
January 28, 2012 at 3:28 pm (UTC 8)
@secretoflife Yea no problem. It just depends on how your workbook is setup but? you can reference cells between separate worksheets to get the job done. Or, just pm me and I’ll try to help you out there.
secretoflife says:
January 28, 2012 at 3:37 pm (UTC 8)
Is there a? way to duplicate totals from monthly tabs onto an annual tab that would keep a tally?
secretoflife says:
January 28, 2012 at 4:26 pm (UTC 8)
Is there a way to? duplicate totals from monthly tabs onto an annual tab that would keep a tally?
Mr1996Alexandru1996 says:
January 28, 2012 at 4:35 pm (UTC 8)
Is there a way to do the? same but get the Difference instead of the Sum?
ExcelisHell says:
January 28, 2012 at 5:13 pm (UTC 8)
@sieghi There should be no problem with that but it depends on the particulars of your situation. If you? private message me on here with more details I can help you more.
sieghi says:
January 28, 2012 at 5:20 pm (UTC 8)
Is there a way to consolidate if the part numbers are? not always identical across worksheets? Some stores have some parts, others have a little overlap but not identical?
ExcelisHell says:
January 28, 2012 at 6:16 pm (UTC 8)
@amkimura The easiest way is a custom macro. ? Private Message me if you need more help.
amkimura says:
January 28, 2012 at 7:08 pm (UTC 8)
Question: how do you go about aggregating data from dozens of workbooks without having to open them and selecting all the ranges? For example, if? I want to consolidate data (same layout) from 30 stores, and I have one file/workbook for each store, how would I aggregate all the data into one single workbook?
thks