copying a range of data multiple times from multiple workbooks

's Computer Specifications

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.

's Computer Specifications

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" <(E-Mail Removed)> wrote in message news:F64F528E-D0F9-48A2-AABF-(E-Mail Removed)...
> 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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying a formula from multiple workbooks down rows and across col	Rookie	Microsoft Excel Programming	3	12th Jan 2010 05:57 PM
RE: Copying a range of data across multiple worksheets	JLGWhiz	Microsoft Excel Programming	0	29th Apr 2009 06:12 PM
Copying a range of data across multiple worksheets	Isaiah Melton	Microsoft Excel Programming	0	29th Apr 2009 05:26 PM
Copying select data frm one workbook to multiple workbooks & save	=?Utf-8?B?UG1hbg==?=	Microsoft Excel Programming	7	2nd Oct 2007 03:08 PM
Help with Macro (copying data from multiple workbooks)	=?Utf-8?B?VGltIEhhcmRpbmc=?=	Microsoft Excel Misc	1	5th Feb 2005 10:37 PM