Consolidate many workbooks into one workbook

's Computer Specifications

Hello,

How do I consolidate many workbooks into one workbook. I have about 10
workbooks and I want to put it into one workbook for my user easier to
maintain. Any tips will be appreciated. Thank you in advance.

Cheers

's Computer Specifications

Ron de Bruin has lots of code samples for different kinds of consolidations:
http://www.rondebruin.nl/tips.htm

CAM wrote:
>
> Hello,
>
> How do I consolidate many workbooks into one workbook. I have about 10
> workbooks and I want to put it into one workbook for my user easier to
> maintain. Any tips will be appreciated. Thank you in advance.
>
> Cheers

--

Dave Peterson

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
consolidate workbooks to worksheets in one workbook?	Neil	Microsoft Excel Misc	1	15th Jul 2009 01:31 PM
Macro To consolidate All Open Workbooks Into One Workbook	=?Utf-8?B?Y2FybA==?=	Microsoft Excel Worksheet Functions	3	31st Mar 2007 04:22 AM
Consolidate Several Workbooks into One	=?Utf-8?B?amVhbm5pZSB2?=	Microsoft Excel Worksheet Functions	1	25th Aug 2006 12:18 PM
consolidate 2 different workbooks	=?Utf-8?B?SmFja2llQg==?=	Microsoft Excel Misc	1	29th Jul 2005 12:02 AM
Consolidate Data from other workbooks	Mike Fogleman	Microsoft Excel Programming	1	24th Oct 2004 09:37 PM