Multiple workbooks

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

HI Guys

yesterday i had a nasty experience of having to copy and paste data
from 120 work books 5 times into a summary work book.

Now i know there are faster ways than this but i am not quite sure of
some of the options.

It maybe a job like this wont come around very often but smaller jobs
will can anyone suggest ways of comabatting this sort of repetition.

as a rule all the data were in identical ranges which i think will
make it simpler to loop through.

any suggestions will canavased

thanks in advance
Greg
 
Greg wrote...
yesterday i had a nasty experience of having to copy and paste
data from 120 work books 5 times into a summary work book. ...
as a rule all the data were in identical ranges which i think will
make it simpler to loop through.
Click to expand...

If you know the filenames, enter them in a list in a new workbook. I
you know the worksheets and ranges within those files, enter then i
different tables in that new workbook. Then try using the firs
alternative in

http://www.google.com/[email protected]
 
Back
Top