copy

J

Joe Roberto

I have more than 300 Excel files with identical format. I would like to copy
same range of data B75:p75 from all these files into one single worksheet in
a Summary file, adding each row for each file.

Please help with the code.
Thank you
 
E

Eduardo

Hi Joe.
look into your other post I answered it with the link to Ron de Bruin web,
it has the macro you need to achieve it
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Codes needed to copy same one row from more than 300 Excel files 1
Cannot copy worksheet to another file 2
Getting Text data using the Data - Subtotal feature 1
Collate data 1
count if multiple sheets in workbook 2
Need to merge worksheets - Excel 2003 0
Create a summary list using same fields from multiple sheets 1
Copy/Paste Question 3

Top