Combine multiple workbooks into one workbook
 

I have about 24 different workbooks which had a different worksheet,
maintained by different users.

Some time to analysis the data, I have to open up all the workbooks and move
the worksheet over manual to form an new workbook.

Is there a command which will copy the data over from each worksheet to one
master workbook, with 24 dofferent worksheets?

Combine multiple workbooks into one workbook
 

YM TEO;282542 Wrote:
I have about 24 different workbooks which had a different worksheet,
maintained by different users.

Some time to analysis the data, I have to open up all the workbooks and
move
the worksheet over manual to form an new workbook.

Is there a command which will copy the data over from each worksheet to
one
master workbook, with 24 dofferent worksheets?

Hi,
does 'this link' (http://www.rondebruin.nl/summary2.htm) provide any
help?


--
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=78926

Combine multiple workbooks into one workbook
 

Hi

take a look at Ron de Bruin's site.
Lots of example code there for dealing with most scenarios
http://www.rondebruin.nl/tips.htm
Scroll down to the Copy/Merge section

--
Regards
Roger Govier

"YM TEO" <YM wrote in message
...
I have about 24 different workbooks which had a different worksheet,
maintained by different users.

Some time to analysis the data, I have to open up all the workbooks and
move
the worksheet over manual to form an new workbook.

Is there a command which will copy the data over from each worksheet to
one
master workbook, with 24 dofferent worksheets?

Combine multiple workbooks into one workbook
 

Hi both,

Thanks for the advice.
But is there another way beside using micro and I'm not good at that and was
totally lost.

"Pecoflyer" wrote:


YM TEO;282542 Wrote:
I have about 24 different workbooks which had a different worksheet,
maintained by different users.

Some time to analysis the data, I have to open up all the workbooks and
move
the worksheet over manual to form an new workbook.

Is there a command which will copy the data over from each worksheet to
one
master workbook, with 24 dofferent worksheets?

Hi,
does 'this link' (http://www.rondebruin.nl/summary2.htm) provide any
help?


--
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=78926

Combine multiple workbooks into one workbook
 

HOW TO ADD AND RUN A MACRO[/b]1. *COPY* THE MACRO ABOVE PRESSING
THE KEYS *CTRL+C
2. Open your workbook
3. Press the keys [b]ALT+F11* to open the Visual Basic Editor
4. Press the keys *ALT+I* to activate the *Insert menu*
5. *Press M* to insert a *Standard Module*
6. *Paste* the code by pressing the keys *CTRL+V*
7. Make any custom changes to the macro if needed at this time.
8. *Save the Macro* by pressing the keys *CTRL+S*
9. Press the keys *ALT+Q* to exit the Editor, and return to Excel.

TO RUN THE MACRO...
To run the macro from Excel, open the workbook, and press *ALT+F8* to
display the *Run Macro Dialog*. Double Click the macro's name to *Run*
it.


--
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=78926