Merging Multiple, but similar, Spreadsheets

[mcman460]

Hi,
I have about 1000 small spreadsheets. They each have the same
columns, but different rows of data - anywhere from 1 row to 250. An
idea how I can easily combine all of these into 1 spreadsheet?
Thanks, Mik

 

[Ron de Bruin]

Hi Mike

Try
http://www.rondebruin.nl/tips.htm

Post back if you need more help

 

[Otto Moehrbach]

Mike
Do you want all the data in all those files to end up in one sheet of
one file? You may run out of rows. Excel allows only 65,536 rows.
Do you want each file's data to go on a separate sheet of the one new
file?
If what Ron gave you does not solve your problem, send me, direct via
email, one of the 1000 files. Also include the full path to the folder that
holds those 1000 files. Are there any files in that folder that you do not
want included in this reorganization of data? Include info about this as
well. My email address is (e-mail address removed) . Remove "cobia97"
from this address. HTH Otto