How to create Macro that can build a Scenario PivotTable Report?
Hi,
As there is no way to refresh a Scenario Pivot Report, I must rebuild it each time my background data changes. To save time, I have tried creating macro command that would build a new Scenario Pivot Report for me. I have recorded the macro by manually creating and formating the Report. In result, the macro command managed to hide fields i did not need, but it failed to assign new data to pivot fields (for example, to move certain data from the column field to the row field). How could I fix this? Thanks in advance, Gerry |
All times are GMT +1. The time now is 01:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com