I Need to copy a column from many worksheets in a folder and paste them in master worksheet or any other column wise. I need the particular column to be copied and pasted in columns of master work book. For example I have 10 workbooks in a folder containing similar type of data. I need to copy column number 6 of all these worksheets and copied to master or a new workbook from column 1 to 10 in a way column 1 of new workbook should be column 6 of workbook 1 in the folder and column 2 of new workbook should be column 6 of workbook 2 in the folder and so on ...
similarly
And a range of cells like A1:A7 from all these workbooks to be copied row wise in another new workbook.