Excel Forum



Consolidate & Combine Data from Separate Worksheets or Workbooks(Excel Files)


This video tutorial will show you how to combine data from separate worksheets, spreadsheets, or workbooks(excel files). This tutorial uses the consolidate feature within excel and teaches you how to make one data sheet that will automatically update when data on other spreadsheets is updated; the original worksheet will have links to the worksheets from where the data is pulled. Additionally, you will also learn how to combine data from separate worksheets while preventing the data from automatically updating.
   Topics Covered
Use the Consolidate Feature to Combine Data from Separate Worksheets or Workbooks(Excel Files)
Automatically Update Consolidated Data
Combine Data into 1 Spreadsheet and allow or prevent Updating
   Difficulty:         Intermediate
   Video:               Yes



Got a Question? Ask it Here in the Forum.