On Oct 8, 5:24 pm, wrote:
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

By the way, the assumption page and pivot table are in the different
tab.

Thanks