Extract specific Cells, and Columns from 50+ workbooks....

Hi All, this is my first time posting so I will try to be as detailed as possible.

I am very new to VBA and am trying to make a macro that can do the following for 50+ identical workbooks with different cell values and combine data in their respective columns:

1. fill a cell with filename
2. Copy A1:B2
3. Copy J6:J95, M6:AI95

I have had luck with youtube demonstrations for copying columns, however I am stuck trying to copy all these at once :(

The end result I am hoping for is something like this:

A1(File name)
A2:B3 (Copy of A1:B2)
C1:Z89 (J6:J95,M6:AI95)

Then after this data,the following workbook copied would start at A96...

Also, copying of just the values would be best and not their original formulas.

Thank you very much!!

Vikas Verma's picture

Please share your workbook

Hi Please share your workbook with a example what output you required....with a dummy data.

warm regards,