| View previous topic :: View next topic |
| Author |
Message |
dotdoms
Newbie
Joined: 30 Oct 2006
Posts: 1
|
 Posted: Mon Oct 30, 2006 3:06 pm Post subject: Fusionating several excel files? |
 |
|
Hello,
I am coming here with a tricky problem - at least itīs a tricky problem for me and my limited skills in that kinda things. So here it is:
I got about 200 Excel - Files which I need to fusionate. Of course I could open every file do a copy and paste, but that would take me ages, since in each file there are several thousands of rows.
Now the columns are for each file the same, so basically all I would need is a way how to kinda set the data of the 2nd file beneath the data of the 1st file, the data of the 3rd file beneath the data of the 2nd, and so on... does there exist a makro or something like that to do that? Or does there exist any other way (except for doing a manual copy and paste)?
thx in advance!  |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
|
| Back to top |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
| Posted: Mon Oct 30, 2006 9:59 pm Post subject: |
|
|
You could just use Insert >Sheet from file. 
_________________
search forum by month |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Tue Oct 31, 2006 4:27 am Post subject: |
|
|
| noranthon wrote: | | You could just use Insert >Sheet from file. |
I was initially going to suggest that, but then got the impression that the information needed to be appended in the same sheet?
David. |
|
| Back to top |
|
|
|
