copy

  • Thread starter Thread starter Joe Roberto
  • Start date Start date
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
 
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
Need to merge worksheets - Excel 2003 0
copy and paste 3 rows run macro and continue to end of columns 1
Collate data 1
Combining data from multiple worksheets into one 4
Getting Text data using the Data - Subtotal feature 1
Copy/Paste Question 3

Back
Top