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.)
I want consolidate the data from different files into one file
Example: I have 3 different files
- The data files are not not available in same page/sheet. The data is in different sheet but data format is same. The data is having more than 10 column headers
- The data sheet is in two currency ( Local & USD seperately)
-The three column data of my new consolidation data should be taken out from First page of the Data file.
Take a look at our tutorial on combining data from multiple worksheets.
Doing this between separate workbooks is basically the same.
Also, here is a tutorial for combining workbooks using a macro.
