How can I combine several excel files into one?
I have 20 excel files and each excel file contains 3 worksheets. How can I
combine these files into one by only a few clicks? In the past, I did it by right click 'move or copy' and one by one. |
How can I combine several excel files into one?
Crystal Lee;191448 Wrote: I have 20 excel files and each excel file contains 3 worksheets. How can I combine these files into one by only a few clicks? In the past, I did it by right click 'move or copy' and one by one. Hi, there are some nice solutions at 'this site' (http://www.rondebruin.nl/copy3.htm) HTH -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52748 |
How can I combine several excel files into one?
But I don't have the right to install anything on my desktop. So, there is
no chance, right? Thanks again. "Pecoflyer" wrote: Crystal Lee;191448 Wrote: I have 20 excel files and each excel file contains 3 worksheets. How can I combine these files into one by only a few clicks? In the past, I did it by right click 'move or copy' and one by one. Hi, there are some nice solutions at 'this site' (http://www.rondebruin.nl/copy3.htm) HTH -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52748 |
How can I combine several excel files into one?
Crystal Lee;214731 Wrote: But I don't have the right to install anything on my desktop. So, there is no chance, right? Thanks again. "Pecoflyer" wrote: Crystal Lee;191448 Wrote: I have 20 excel files and each excel file contains 3 worksheets. How can I combine these files into one by only a few clicks? In the past, I did it by right click 'move or copy' and one by one. Hi, there are some nice solutions at 'this site' ('Merge data from all workbooks in a folder (1)' (http://www.rondebruin.nl/copy3.htm)) HTH -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers ------------------------------------------------------------------------ Pecoflyer's Profile: 'The Code Cage Forums - View Profile: Pecoflyer' (http://www.thecodecage.com/forumz/me...pecoflyer.html) View this thread: 'How can I combine several excel files into one? - The Code Cage Forums' (http://www.thecodecage.com/forumz/sh...ad.php?t=52748) Ron's site provides macro's, so you can install them yourself in XL, or is this possibility blocked? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52748 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com