Combine many exel files to one

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MichalH - 27 Mar 2006 16:47 GMT

Please, help. I got many exel files with diferent names but with the same
layout.
How can I combine the files to one sheet? For example.I have 50 files and
every file has 100 row. I need one file with 5000 rows.
Thanks

Reply to this Message

Peo Sjoblom - 27 Mar 2006 17:52 GMT

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

Signature

Regards,

Peo Sjoblom

> Please, help. I got many exel files with diferent names but with the same
> layout.
> How can I combine the files to one sheet? For example.I have 50 files and
> every file has 100 row. I need one file with 5000 rows.
> Thanks

Reply to this Message