VBA coding across different workbooks

[Novicesportsperformer]

Hi,

Wondering If anyone can help me here?

I have 240 different work books that I need to copy into an existing separate workbook table.

Each workbook I specifically need columns A - Y, Rows 12 - 25 and also Columns A - Y, Rows 29 - 41 to be copied underneath one and other into a separate workbooks to form a large table.

Could anyone help me on this please?

thank you very much

 

[My Aswer Is This]

You really mean 240 Workbooks?
Not Worksheet?

So how would we know what 240 Workbooks.
What sheet name in each workbook?

 

[dmt32]

Hi,
Have a look at Ron de Bruin's site:https://www.rondebruin.nl/win/s3/win008.htm

and see if his approach is something that meets your requirement


Dave

 

[Novicesportsperformer]

Sorry I should have clarified,

Yes it's 240 workbooks, with only one worksheet in each of the workbooks.

Each Workbook has a distinct name ie summary1, summary2 ect with the worksheet being the same name as the workbook.

It is a little over my expertise and so I thought I would ask for help on this

Thank you in advance if you can help!

 

[Novicesportsperformer]

Thank you, I will have a look at this now!