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

Embed the same Excel multiple times 0
Visio to Excel 0
Mail Merge Directory Conditional Page Break 0
Possible to Combine reports to's to a single box? 0
Remove Identical words 0
Cell data entering slow! 0
Merging from an Excel file with graphics 1
Cannot copy worksheet to another file 2

Top