[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[_236_]]

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

[Roger Govier[_3_]]

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?

[YM TEO[_2_]]

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

[Pecoflyer[_249_]]

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