Consolidate multiple spreadsheets

I receive multiple spreadsheets each week as part of a survey. I need to
consolidate several of the fields onto one spreadsheet. How can I use
VBA/macro/function to consolidate the information from several spreadsheets
to one spreadsheet without having to open all the spreadsheets?
Thank you.

If you just mean append the information down a single sheet, then just
search google groups for consolidate


http://groups.google.co.uk/groups?as...ming&lr=&hl=en


the URL should all be on one line

--
Regards,
Tom Ogilvy

"Rob" <[email protected]> wrote in message
news:[email protected]...
> I receive multiple spreadsheets each week as part of a survey. I need to
> consolidate several of the fields onto one spreadsheet. How can I use
> VBA/macro/function to consolidate the information from several
spreadsheets
> to one spreadsheet without having to open all the spreadsheets?
> Thank you.

I have some examples on my website
http://www.rondebruin.nl/tips.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Rob" <[email protected]> wrote in message news:[email protected]...
>I receive multiple spreadsheets each week as part of a survey. I need to
> consolidate several of the fields onto one spreadsheet. How can I use
> VBA/macro/function to consolidate the information from several spreadsheets
> to one spreadsheet without having to open all the spreadsheets?
> Thank you.

Tom,
Thank you for the assistance.
I should have said multiple workbooks instead of multiple worksheets. Will
the macro you referenced work for multiple workbooks as well? I need
information from the first spreadsheet of 50 different workbooks put on the
first spreadsheet of one workbook.

"Tom Ogilvy" wrote:

> If you just mean append the information down a single sheet, then just
> search google groups for consolidate
>
>
> http://groups.google.co.uk/groups?as...ming&lr=&hl=en
>
>
> the URL should all be on one line
>
> --
> Regards,
> Tom Ogilvy
>
> "Rob" <[email protected]> wrote in message
> news:[email protected]...
> > I receive multiple spreadsheets each week as part of a survey. I need to
> > consolidate several of the fields onto one spreadsheet. How can I use
> > VBA/macro/function to consolidate the information from several
> spreadsheets
> > to one spreadsheet without having to open all the spreadsheets?
> > Thank you.
>
>
>

the reference references responses to hundreds of posts asking questions on
either consolidating multiple sheets or multiple workbooks.

You should find a solution that fits your needs within the list.

--
Regards,
Tom Ogilvy

"Rob" <[email protected]> wrote in message
news:[email protected]...
> Tom,
> Thank you for the assistance.
> I should have said multiple workbooks instead of multiple worksheets.
Will
> the macro you referenced work for multiple workbooks as well? I need
> information from the first spreadsheet of 50 different workbooks put on
the
> first spreadsheet of one workbook.
>
> "Tom Ogilvy" wrote:
>
> > If you just mean append the information down a single sheet, then just
> > search google groups for consolidate
> >
> >
> >
http://groups.google.co.uk/groups?as...ming&lr=&hl=en
> >
> >
> > the URL should all be on one line
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Rob" <[email protected]> wrote in message
> > news:[email protected]...
> > > I receive multiple spreadsheets each week as part of a survey. I need
to
> > > consolidate several of the fields onto one spreadsheet. How can I use
> > > VBA/macro/function to consolidate the information from several
> > spreadsheets
> > > to one spreadsheet without having to open all the spreadsheets?
> > > Thank you.
> >
> >
> >