Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MichalH
 
Posts: n/a
Default Combine many exel files to one

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

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Combine many exel files to one

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


--

Regards,

Peo Sjoblom


"MichalH" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
exel files are not opening? Tushar Excel Discussion (Misc queries) 1 March 21st 06 11:49 AM
Combine worksheets from different excel files into one excel file dbguy11 Excel Discussion (Misc queries) 2 February 27th 06 03:06 PM
combine multiple worksheets & files into 1 Barb Excel Worksheet Functions 3 October 7th 05 11:43 PM
combine two files Charles Excel Discussion (Misc queries) 1 August 9th 05 09:46 PM
how to combine multiple files in ms excel fifi Excel Discussion (Misc queries) 1 January 12th 05 11:11 AM


All times are GMT +1. The time now is 11:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"