copying a range of data multiple times from multiple workbooks

S

sot

Is there a way I can copy the same range of 20 rows from 6 specific columns
out of 700 workbooks into one workbook each week.
 

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
Auto Merge text from multiple sources 0
Add additional information to excel form after original data entry 0
Range headings 0
Copy addition formula of non-consecutive horizontal cells 2
Dealing with a Pivot Table (when I don't want to) 0
Use a master workbook to carry over changes to multiple workbooks 1
Open four Wbooks, copy four columns from each to Master Wbook 16

Top