V
vincentwady
dear all,
I have a set of pivot table output. I want to create a VBA based on my
8 different senarios. I know the process is I apply the senario 1 in
the assumption control cell, and copy the pivot table output from my
pivot table and paste the value and formating on a preset printing
area. And then go to second senario and repeat the same thing till the
last senario.
Do anyone know how I should start and be able to run VBA for a better
way?
Thanks
Vincent
I have a set of pivot table output. I want to create a VBA based on my
8 different senarios. I know the process is I apply the senario 1 in
the assumption control cell, and copy the pivot table output from my
pivot table and paste the value and formating on a preset printing
area. And then go to second senario and repeat the same thing till the
last senario.
Do anyone know how I should start and be able to run VBA for a better
way?
Thanks
Vincent