| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how can I combine multiple worksheets into a single workbook?
I make daily spreadsheets with all the same columns and variable numbers of
rows; I want to combine all the worksheets from a month into a single workbook file. Each of the previous files should be separate worksheets in the new master workbook. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I combine multiple worksheets into a single workbook?
Does 'this link' (http://www.rondebruin.nl/merge.htm) help ? -- Pecoflyer Cheers - *_Membership_is_free_* & 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=45947 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I combine multiple worksheets into a single workbook?
Looks like you have one sheet per workbook and want to move all sheets to one
workbook. Are you looking for an automated solution or are you willing to do it manually? Manual method - Open the destination workbook Open the source workbooks one by one Rightclick on the sheet to move and choose Move or copy Select destination Hope someone else will provide an automated solution or you can search the forum... "don_15D" wrote: I make daily spreadsheets with all the same columns and variable numbers of rows; I want to combine all the worksheets from a month into a single workbook file. Each of the previous files should be separate worksheets in the new master workbook. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I combine multiple worksheets into a single workbook?
I did not ask the correct question. I have a sort of template sheet I copy
into a workbook that has many sheets. Each sheet has a unique name and I created a macro to count certain data in each sheet. The macro also inputs two new columns, names the rows I want and places the counts into the proper row. I need a way to transfer the data from say sheet AE1 cell B1 to sheet Data cell B3. Sheet AE1 cell B2 to Data cell B4, etc. I have about 22 worksheets in each workbook to copy data from. I appreciate the help. "Pecoflyer" wrote: Does 'this link' (http://www.rondebruin.nl/merge.htm) help ? -- Pecoflyer Cheers - *_Membership_is_free_* & 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=45947 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I combine multiple worksheets into a single workbook?
Though I didn't say so, I was looking for some automated method. I understand
about creating new worksheets in a destination workbook and then populating it with the contents of the source worksheet. For example December, this would be lots of repetitive tasks creating a consolidated workbook. Is there an automated solution to do this? "Sheeloo" wrote: Looks like you have one sheet per workbook and want to move all sheets to one workbook. Are you looking for an automated solution or are you willing to do it manually? Manual method - Open the destination workbook Open the source workbooks one by one Rightclick on the sheet to move and choose Move or copy Select destination Hope someone else will provide an automated solution or you can search the forum... "don_15D" wrote: I make daily spreadsheets with all the same columns and variable numbers of rows; I want to combine all the worksheets from a month into a single workbook file. Each of the previous files should be separate worksheets in the new master workbook. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I combine multiple worksheets into a single workbook?
Try
http://www.rondebruin.nl/summary.htm Or http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "wcurtis" wrote in message ... I did not ask the correct question. I have a sort of template sheet I copy into a workbook that has many sheets. Each sheet has a unique name and I created a macro to count certain data in each sheet. The macro also inputs two new columns, names the rows I want and places the counts into the proper row. I need a way to transfer the data from say sheet AE1 cell B1 to sheet Data cell B3. Sheet AE1 cell B2 to Data cell B4, etc. I have about 22 worksheets in each workbook to copy data from. I appreciate the help. "Pecoflyer" wrote: Does 'this link' (http://www.rondebruin.nl/merge.htm) help ? -- Pecoflyer Cheers - *_Membership_is_free_* & 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=45947 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how can I combine multiple worksheets into a single workbook?
I looked over the link and the code, and it looks like it will work for me.
Many thanks! "Pecoflyer" wrote: Does 'this link' (http://www.rondebruin.nl/merge.htm) help ? -- Pecoflyer Cheers - *_Membership_is_free_* & 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=45947 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combine data from several worksheets into single worksheet | Excel Discussion (Misc queries) | |||
| Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
| 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 different worksheets to a single worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
