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.

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

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

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