One Excel workbook out of many

[jeff.white]

Is there an easy way to combine many excel workbooks into one new
one? In a perfect world, what I'd like really is only the first 6
columns of each workbook. Here's what I have, an active employee list
that is run each day. They are saved with the current day's date, for
example today's is: 06-15-07.xls. Each workbook contains roughly 1600
rows. Each column has the same headers in each of the files. If it
were easier, I could combine all columns, then once combined delete
the one's I don't need. Any ideas?

 

[Don Guillett]

Doable.
How many workbooks? If you want to combine 1600 rows into 65000 rows, need
less than 40.
Are they all in the same folder?
Are they all on the same worksheet? If so, which one?

 

[Ron de Bruin]

Start here Jeff
http://www.rondebruin.nl/copy3.htm