Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Create Workbooks & Worksheets
I have 2 seperate macro's.
Macro2 -creates a worksheet for each PCT Macro1- creates a workbook for Health Authority. I would like to combine the two, so that after extracting data needed to create each workbook I use it as the datasource to create the pivot table. Macro 1 is based on the example-Create a new sheet for all Unique values Macro 2 is based on the example-Create a new workbook for each value both on http://www.rondebruin.nl/copy5.htm#workbook Is there are way to integrate the macros so that it a workbook is created with macro 1 and then within this new workbook, worksheets are created for each HA using macro 2? Also I wondered how I would going about using a template to generate the workbooks. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a macro that compares two workbooks | Excel Discussion (Misc queries) | |||
can't create excel add-in macro to use with other workbooks | Excel Programming | |||
Macro to create workbooks and pivot tables | Excel Programming | |||
Auto Create workbooks and worksheets per columnar data | Excel Programming | |||
Create workbooks from worksheets | Excel Discussion (Misc queries) |