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. |
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. |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com