S sot Nov 23, 2009 #1 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.
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.
R Ron de Bruin Nov 23, 2009 #2 Hi sot See http://www.rondebruin.nl/copy3.htm Try the add-in http://www.rondebruin.nl/merge.htm