Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto insert of a pivot table?
Would someone out there let me know if there is a way to write a code/macro
that allows you to insert a pivot table worksheet in the active workbook? I add a pivot table to every work book I open. Each workbook has only 1 work sheet (the pivot table would be the second sheet) The problem with "recording" a macro is the source data changes with every book I open as does the number of rows. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto insert of a pivot table?
I already gave you the answer to this question. Did you try what I
recommended? I don't think you did... Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Evil with a K" wrote: Would someone out there let me know if there is a way to write a code/macro that allows you to insert a pivot table worksheet in the active workbook? I add a pivot table to every work book I open. Each workbook has only 1 work sheet (the pivot table would be the second sheet) The problem with "recording" a macro is the source data changes with every book I open as does the number of rows. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert a row in a pivot table? | Excel Worksheet Functions | |||
Insert formula in a pivot table | Excel Discussion (Misc queries) | |||
PIVOT TABLE HOW TO INSERT....... | Excel Discussion (Misc queries) | |||
Pivot Table Refresh - Auto insert row | Excel Discussion (Misc queries) | |||
Insert a row after a pivot table | Excel Discussion (Misc queries) |