Consolidate multiple spreadsheets

[Guest]

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 Ogilvy]

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


http://groups.google.co.uk/groups?a...=microsoft.public.excel.programming&lr=&hl=en


the URL should all be on one line

 

[Ron de Bruin]

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

 

[Guest]

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]

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.