Condencing several reports into one spreadsheet

[craigwms]

Greetings,

Hope all is going well on this last hump-day of August ‘06. How do I put several spreadsheets into one big spreadsheet? I have about 100 different spreadsheets that need to be placed into one big spreadsheet. I've been cutting and pasting but feel there should be a better way.

Thanks in advance for your advice.

C

 

[texasalynn]

there are many great suggestions on this forum for this. Do a search on "consolidate"

here is one
http://www.mrexcel.com/board2/viewtopic.php?t=209536

 

[craigwms]

Thanks Texaslynn

I appreciate your reply, however this link provides Macros for compiling various worksheets into one worksheet.

My issue is combining various spreadsheets (about 400) into one spreadsheet.

Is there another thread on this?

I keep searching.

C