Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use VBA for updating pivot table
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use VBA for updating pivot table
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating pivot table.! | Excel Discussion (Misc queries) | |||
Pivot Table updating | Excel Discussion (Misc queries) | |||
Pivot Table - Updating | Excel Discussion (Misc queries) | |||
updating pivot table | Excel Discussion (Misc queries) | |||
Pivot Table not Updating | Excel Worksheet Functions |