Hi Team,

I have around 20 files in a drive and a summary workbook. All that I would like to achieve is, from all the files, I want column (B, C, N, O, Z, AP, AQ) come into summary workbook one below another. All these column has to be placed in same columns in summary workbook as well.

Here, I want macro to copy all the specified columns from row 2 since row 1 has a heading and paste in row 3 in summary workbook since row 1 and 2 has a merged heading. Also, I would like to retain the values, formats, comments if any and validations.


Please advice is it possible. Any help that you could provide on this would be really appreciated.


Thanks,
Vignesh