Combine multiple workbooks into one workbook

[YM TEO]

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?

 

[Pecoflyer]

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 an
move
the worksheet over manual to form an new workbook.

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

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

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Roger Govier]

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

 

[Pecoflyer]

HOW TO ADD AND RUN A MACRO[/B]1. *COPY* THE MACRO ABOVE PRESSIN
THE KEYS *CTRL+
2. Open your workbook
3. Press the keys 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* t
display the *Run Macro Dialog*. Double Click the macro's name to *Run
it

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste