Macro to copy one column from several workbooks into a single workbook

Hello,

Apologies if this has been posted before, but I haven't found a solution yet.

I'm hoping to copy the same column from 115 different workbooks into a single workbook, with each column copied into a separate column in the new workbook (the end result would be a workbook with 115 columns).

In addition, I need to do this for columns in three different sheets of each of the 115 workbooks. Specifically, I need to copy column Z of sheet 1, column AL of sheet 2, and column AD of sheet 3.

I am new to using macros so I have no idea how to do this- any help would be very appreciated.

Thanks!

So what you need is a macro that loops through all the 115 files in a specific folder (I assume all these files are in the same folder)

the end result would be a workbook with 115 columns

You say that each of these files contains 3 worksheets and you wish to copy column Z, AL and AD so the values from the first file and sheet1 will be pasted to column A in target file, the next set of values from first file and sheet2 should also be pasted to column A below the values from sheet1 and finally the last set of data from sheet3 will also be pasted to column A in target file. Then the processed file is closed and the next file is opened and the process is repeated this time in the B column ........

Perhaps the file name should be added on top of each column for easy identification in case some value must be "investigated"?

Looking at your forum profile I see it says "Excel 2011". As far as I know this is the Mac version of Excel so a code writen for Excel 2010 may not work in a Mac environment.

I would recommend that you upload one of the 115 files (after checking that there is no sensitive in it) in order to make it easier to write a macro.

Alf