Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to combine or import multiple Excel workbooks? | Excel Worksheet Functions | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into one workbook | Excel Discussion (Misc queries) | |||
Combine tabs from multiple workbooks into one | Excel Discussion (Misc queries) |