Merging Multiple, but similar, Spreadsheets

M

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
 
O

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 [email protected] . Remove "cobia97"
from this address. HTH Otto
 
Top