Combine Multiple Spreadsheets

[CCourtois]

I have about 200 separate spreadsheet files that I need
to combine into one. Other than copying and pasting I
don't know how to do this. Can it even be done?
Thanks,
Cory

 

[Myrna Larson]

With a macro, it can be done.

To give you any needed help with that requires precise information about the layout (presumably
they are all the same?), how you want them combined (onto 1 sheet, multiple sheets in one
book?), where the 200 files are located, etc.

 

[Jean]

Open a new workbook and the spreadsheet(s) that you want
to combine. Right click on the sheet tab and select Move
or Copy. Indicate which book (probably the new workbook)
you wamt to copy the sheet to, where you want it, and
REMEMBER to check off "Create a Copy" if you want the
sheet to remain in the original file.

 

[Ron de Bruin]

Try this example

http://www.rondebruin.nl/copy3.htm

Post back if you need help