Macro to merge multiple files to one for selected column only

[Closed]
Report
Posts
1
Registration date
Saturday March 28, 2015
Status
Member
Last seen
March 28, 2015
-
Hi,
I have hundreds of excel files that I want to combine into one file. The problem is that these files contain hundreds of columns of extra data that I do not need. Further complicating things is that the column positions differ between workbooks and workbooks have differing number of columns. I want to create a macro that will go through and open each file, search for the columns I need, and then copy those columns of data and combine them into one master file.

Many Thanks,
Jayesh