| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i automate copying of tabs to a new workbook?
I have a workbook has the same tabs every month and each month I need to
parse out the tabs in the same way to separate workbooks. Is there a way to automate this? As an example, let's say my workbook has 10 tabs labeled tab1 to tab10. Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook, etc. I don't know VBA at all, can anyone help? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i automate copying of tabs to a new workbook?
See
http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "emme" wrote in message ... I have a workbook has the same tabs every month and each month I need to parse out the tabs in the same way to separate workbooks. Is there a way to automate this? As an example, let's say my workbook has 10 tabs labeled tab1 to tab10. Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook, etc. I don't know VBA at all, can anyone help? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i automate copying of tabs to a new workbook?
thank you. is there a way to copy only certain tabs? i need to parse out to
several separate workbooks. how would i modyify your code? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "emme" wrote in message ... I have a workbook has the same tabs every month and each month I need to parse out the tabs in the same way to separate workbooks. Is there a way to automate this? As an example, let's say my workbook has 10 tabs labeled tab1 to tab10. Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook, etc. I don't know VBA at all, can anyone help? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how can i automate copying of tabs to a new workbook?
What is the criteria ?
Sheets names that start with ? -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "emme" wrote in message ... thank you. is there a way to copy only certain tabs? i need to parse out to several separate workbooks. how would i modyify your code? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy6.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "emme" wrote in message ... I have a workbook has the same tabs every month and each month I need to parse out the tabs in the same way to separate workbooks. Is there a way to automate this? As an example, let's say my workbook has 10 tabs labeled tab1 to tab10. Every month I need to put tab1 and tab2 in a workbook, tab3 in a workbook, etc. I don't know VBA at all, can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 07: Copying data between tabs in a workbook (automatically) | Excel Discussion (Misc queries) | |||
| How can I automate the naming of worksheet tabs? | Excel Discussion (Misc queries) | |||
| How to automate custom footer on all tabs | Excel Discussion (Misc queries) | |||
| Copying tabs from one workbook to another workbook | Excel Programming | |||
| Copying tabs in a workbook | Excel Programming | |||
Hybrid Mode
