Consolidating spreadsheets

's Computer Specifications

Does anyone have an easy code to consolidate all workbooks within a
specified folder?

Create new workbook
Get contents of workbook1
Paste into new workbook
Get contents of workbook2
Paste under contents of workbook 1 in new workbook
Get contents of workbook3....

Until there are no more workbooks in that folder.

's Computer Specifications

Hi Jess

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

--

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

"Jess" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Does anyone have an easy code to consolidate all workbooks within a
> specified folder?
>
> Create new workbook
> Get contents of workbook1
> Paste into new workbook
> Get contents of workbook2
> Paste under contents of workbook 1 in new workbook
> Get contents of workbook3....
>
> Until there are no more workbooks in that folder.
>

's Computer Specifications

Thanks!!!

Ron de Bruin wrote:
> Hi Jess
>
> See this page
> http://www.rondebruin.nl/copy3.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Jess" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> > Does anyone have an easy code to consolidate all workbooks within a
> > specified folder?
> >
> > Create new workbook
> > Get contents of workbook1
> > Paste into new workbook
> > Get contents of workbook2
> > Paste under contents of workbook 1 in new workbook
> > Get contents of workbook3....
> >
> > Until there are no more workbooks in that folder.
> >

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Consolidating data from multiple spreadsheets...	Morgan DeMarco	Microsoft Excel Misc	2	12th Feb 2008 01:39 PM
Consolidating data from many spreadsheets and comparing results over time	Dave	Microsoft Excel Programming	1	28th Aug 2006 07:05 PM
Can Excel Spreadsheets be saved as Microsoft Works spreadsheets?	=?Utf-8?B?RVhDRUwgV09SS1MgQ09ORlVTRUQ=?=	Microsoft Excel Misc	4	18th Aug 2006 11:21 PM
Consolidating several spreadsheets	Linda J	Microsoft Excel Misc	2	12th May 2006 10:45 AM
Consolidating spreadsheets	=?Utf-8?B?QUNhc2U=?=	Microsoft Excel Worksheet Functions	1	26th Oct 2005 08:33 PM