Opening multiple Excel files into one spreadsheet

[Robin]

This probably isn't possible, but before I start doing this manually
I'd thought I'd ask...

I've a number of Excel files all in the same format (inventory) I'd
like to compile into one big spreadsheet. Normally I'd just open them
then copy and paste the info I wanted. Howerver there's something like
200 of these files, so even if they are relatively small the simple
act of open, copy, paste, close, times 200 is a lot of time. Is there
anyway to select them all and comile them into one spreadsheet
automatically?

 

[Bob Greenblatt]

This probably isn't possible, but before I start doing this manually
I'd thought I'd ask...

I've a number of Excel files all in the same format (inventory) I'd
like to compile into one big spreadsheet. Normally I'd just open them
then copy and paste the info I wanted. Howerver there's something like
200 of these files, so even if they are relatively small the simple
act of open, copy, paste, close, times 200 is a lot of time. Is there
anyway to select them all and comile them into one spreadsheet
automatically?

Look in help for "consolidate" I think this will get you what you want.