Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.