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