How to do a Macro in Excel 2013 to consolidate the data from different files


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.


Answer the Question

You must create an account to use the forum. Create an Account or Login