Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro help!
I have 2 seperate macro's.
Macro1 -creates a pivot table Macro2- creates a workbook for each practice. 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. Macro2 is based on the example on this website which creates a new workbook for each value. http://www.rondebruin.nl/copy5.htm#workbook I need seperate workbooks as it is confidential information... and as I will be doing this weekly, I would like to have a nice easy macro or procedure to run, instead of having to create 30 pivot tables. Im sure this will be easy for someone. If this is not the best approach pls advise.Many thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro help!
See your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl wrote in message ups.com... I have 2 seperate macro's. Macro1 -creates a pivot table Macro2- creates a workbook for each practice. 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. Macro2 is based on the example on this website which creates a new workbook for each value. http://www.rondebruin.nl/copy5.htm#workbook I need seperate workbooks as it is confidential information... and as I will be doing this weekly, I would like to have a nice easy macro or procedure to run, instead of having to create 30 pivot tables. Im sure this will be easy for someone. If this is not the best approach pls advise.Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error when running cut & paste macro | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions |