copying a range of data multiple times from multiple workbooks
 

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.

copying a range of data multiple times from multiple workbooks
 

Hi sot

See
http://www.rondebruin.nl/copy3.htm

Try the add-in
http://www.rondebruin.nl/merge.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"sot" wrote in message ...
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.